oracle 这个看似简单的查询。。能用SQL实现吗？
0
所有回答(2)
0
select m,max(n) as cj from datetable group by m
union all
select m,max(n) as cj from datatable a , (select m,max(n) as cj from datetable group by m ) b where a.m=b.m and a.n<>b.cj group by m
0
分组排序的问题啊：
select * from( select studentID,score, row_number() over (partition by score order by studentID desc) as rowno from table1) A where a.rowno<=2
这种方式感觉更容易理解
