SqlServer: Top N per Group

在sqlserver中可以这样显示分组前N个成员, 关键在row_number, partition

select * from
(select schoolmember_id, row_number() over(partition by school_id order by schoolmember_id ) as number from schoolmember) as a
where a.number < 3

posted @   dragonpig  阅读(362)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示