再一次排序:找出每一组中序号为一的数据
-
select * from(select id,name,age,salary,row_number()over(partition by id order by salary desc) rank
-
from TEST_ROW_NUMBER_OVER t)
-
where rank <2
再一次排序:找出每一组中序号为一的数据
select * from(select id,name,age,salary,row_number()over(partition by id order by salary desc) rank
from TEST_ROW_NUMBER_OVER t)
where rank <2