22,209
社区成员
发帖
与我相关
我的任务
分享
select a.*
from Invitation a
inner join (select top 5 InvitationID from Comment group by InvitationID order by count(1) desc) b on a.InvitationID=b.InvitationID
select *
from Invitation
where id in(select top 5 InvitationID from Comment group by InvitationID order by count(1) desc)