select s_id, r_id
from (
select row_number () over (partition by s_id,r_id order by r_id desc) rn,--以s_id,r_id分组,分组内以r_id倒序排列求每组中各自的序号
m, n
from table
where ...
) w
where w.rn <=10;序号小于10
mysql 获取按某几个字段分组数据的前十条记录
最新推荐文章于 2024-05-08 09:29:16 发布