22,209
社区成员
发帖
与我相关
我的任务
分享
select top 10 ID,GroupName , count(1) as 人数,ROW_NUMBER() OVER(ORDER BY COUNT(1) DESC) AS rownum
from dbo.GroupInfo a left join dbo.UserAccount b on a.id= b.Groupid
group by ID,GroupName
order by Count(1) desc
select t.*,
(select count(1) from (select top 10 ID,GroupName , count(1) as 人数 from dbo.GroupInfo a left join dbo.UserAccount b on a.id= b.Groupid group by ID,GroupName order by Count(1) desc) tt where tt.人数>=t.人数) as 社团排序
from (select top 10 ID,GroupName , count(1) as 人数 from dbo.GroupInfo a left join dbo.UserAccount b on a.id= b.Groupid group by ID,GroupName order by Count(1) desc) t