select * (select rank() over(order by score desc) rank ,t1.* from t1) where rank < 7
结果:
rank name score
1 a 100
2 b 99
2 c 99
2 d 99
5 e 98
6 f 97
select * (select DENSE_RANK() over(order by score desc) rank ,t1.* from t1) where rank < 5
结果:
rank name score
1 a 100
2 b 99
2 c 99
2 d 99
3 e 98
4 f 97