分组排序,取top值
select * from (select id,row1,ROW_NUMBER() over (partition by id order by row1 desc) as rownum from admin.a)as s where s.rownum<=5;
【mysql】分组排序,取top值
最新推荐文章于 2024-05-13 16:09:50 发布
分组排序,取top值
select * from (select id,row1,ROW_NUMBER() over (partition by id order by row1 desc) as rownum from admin.a)as s where s.rownum<=5;