本文介绍了一种使用 SQL 实现分区并按指定字段降序排列的方法，同时筛选出每个分区内的特定记录。通过 `ROW_NUMBER()` 函数结合 `PARTITION BY` 和 `ORDER BY` 子句实现这一目标。
select a,b from( select a,b,
row_number() over(partition by a order by b desc) as rid
from TAB_表 order by b desc )
where rid = 1 and rownum < 21 order by b desc
row_number() over(partition by a order by b desc) as rid
from TAB_表 order by b desc )
where rid = 1 and rownum < 21 order by b desc
扫一扫
926
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
