分析函数的使用:
select field1,field2,field3,field4 from
(select field1,field2,field3,field4,row_number() over (partition by field1 order by field2) rn from abcd)
where rn = 1;
主要是分析函数的用法
照着nyfor大虾的思路
换一个分析函数就行了
select field1, field2, field3, field4
from ( select field1, field2, field3, field4, rank() over (partition by field1 order by field2) rk from abcd )
whererk = 1;