17,377
社区成员
发帖
与我相关
我的任务
分享
RANK() OVER(PARTITION BY COLUMNNAME ORDER BY COLUMNAME)
ROW_NUMBER() OVER(PARTITION BY COLUMNNAME ORDER BY COLUMNAME)
select sid,name,deptno from (select row_number() over(partition by deptno order by sid)rn,sid,name,deptno from 你的表) where rn<3;