三条SQL语句只有一条可以执行?

[makoshen]

1 strsql="select adduser,count(id) as num from [xxbs] where adduser in (select id from [uxxbs] where dj=1) group by adduser order by count(id) desc"

2 strsql="select adduser,danwei,count(id) as num from [xxbs] where adduser in (select id from [uxxbs] where dj=1) group by adduser order by count(id) desc"

3 strsql="select * count(id) as num from [xxbs] where adduser in (select id from [uxxbs] where dj=1) group by adduser order by count(id) desc"



第一个语句可以执行;需要加个字段显示,第二不可以执行超时,第三个也不可以执行,
请问想多显示个字段danwei 怎么在第一条SQL语句写.

[hookee]

strsql="select adduser,danwei,count(id) as num from [xxbs] where adduser in (select id from [uxxbs] where dj=1) group by adduser, danwei order by count(id) desc"

[makoshen]

第二条不能执行 一执行就超时 为什么?

[hookee]

逻辑上只有按照adduser,danwei分组才能取每组的聚集函数，只按adduser分组的话，选danwei字段表示不出其意义了

[makoshen]

谢谢