17,086
社区成员
发帖
与我相关
我的任务
分享
select t4.pfid, t4.njid, t3.bjid
from (select t2.*, row_number() over(partition by pfid order by njid) rnn
from (select nj.pfid, bj.njid
from nj
left join bj
on nj.njid = bj.njid
group by nj.pfid, bj.njid) t2) t4,
bj t3
where t4.njid = t3.njid
and t4.rnn <= 10
order by t4.pfid, t4.njid, t3.bjid