急求，在线等一个sql查询语句，高手快来！

[wonder927]

两个表
表1 ques
quesid userid
1 1
2 3
3 4
4 3
5 4
6 3
7 2
8 1

表2 user
userid
1
2
3
4
请问如何吧userid 按在ques表中的个数由到少排序？
需要的结果应该是 userid 3，1，4，2
急，在线等，谢谢高手快来！

[lsqkeke]

不知道你是哪种：


select a.userid from [user] a,(select userid,amount=count(1) from ques group by userid)b
where a.userid=b.userid
order by amount desc


select userid,amount=count(1) from ques group by userid order by amount desc

[wonder927]

是第二种，谢谢！

[-狙击手-]

declare @t table(quesid int,userid int)
insert @t
select 1,1 union all
select 2,3 union all
select 3,4 union all
select 4,3 union all
select 5,4 union all
select 6,3 union all
select 7,2 union all
select 8,1


select userid
from @t
group by userid
order by sum(quesid) desc



/8


userid
-----------
3
1
4
2
*/