sqlserver:select * from (select *,row_number() over(partition by 分组列 order by 组内排序列) as rn from table) as a where rn<=2
where rownum<=行数
where rownum <= 数字 你懂了吗？
