17,090
社区成员
发帖
与我相关
我的任务
分享
select a.*
from(
select t.*,rank() over(partition by t.depart_name order by t.depart_name) num
from test t) a
where a.num < 4
select a.*
from(
select t.*,row_number() over(partition by t.depart_name order by t.depart_name) num
from test t) a
where a.num < 4