1、sql 语法
select m, n
from (
select row_number () over (partition by m order by n desc) rn,--以m分组,分组内以n倒序排列求每组中各自的序号
m, n
from table
where ...
) w
where w.rn
1、sql 语法
select m, n
from (
select row_number () over (partition by m order by n desc) rn,--以m分组,分组内以n倒序排列求每组中各自的序号
m, n
from table
where ...
) w
where w.rn