FA FB FC(field)
a c1 9
a c2 3
a c9 5
b c2 8
b c1 5
b c4 9
得到
FA FB FC(field)
a c1 9
a c9 5
b c4 9
b c2 8
即每组(FA栏位a,b)取FC栏位前两个值的记录,并按由大到小排列。
a c1 9
a c2 3
a c9 5
b c2 8
b c1 5
b c4 9
得到
FA FB FC(field)
a c1 9
a c9 5
b c4 9
b c2 8
即每组(FA栏位a,b)取FC栏位前两个值的记录,并按由大到小排列。
(select t.*,rank() over(partition by FA order by FC desc) rn from table t)
where rn<3
(select t.*,rank() over(partition by FA order by FC desc) rn from table t)
where rn<3 order by FA asc,FC desc;
select MOD(ROWNUM-1,a.rn)+1 ,....
order by ....,MOD(ROWNUM-1,a.rn)+1
select t.*,rank() over(partition by substr(FA,1,1) order by FC desc ) rn from table t