在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
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。