这个分组查询怎么写？

[风中云]

如题：table表字段：serialno,username,cellphone,accountid,groupid
根据groupid分组查询，我想得到每组的cellphone（手机号）数据，我sql这样写
“select count(cellphone) from mdao_member where accountid = ? group by groupid”得到是每组的手机个数，
可是我想得到cellphone的具体数据该怎么做？

[rov_88]

select cellphone,count(1) from mdao_member where accountid = ? group by cellphone

[AcHerat]

select groupid,cellphone
from tb
order by groupid

[AAACCCEEEFFFA]

分开查询吧。

[风中云]

[Quote=引用 2 楼 acherat 的回复:]
select groupid,cellphone
from tb
order by groupid
[/Quote]
汗，分组查询啊

[风中云]

[Quote=引用 1 楼 rov_88 的回复:]
SQL code

select cellphone,count(1) from mdao_member where accountid = ? group by cellphone
[/Quote]
要按groupid分组查询的，如果按cellphone那不是每个号码都是一个组了

[风中云]

[Quote=引用 2 楼 acherat 的回复:]
select groupid,cellphone
from tb
order by groupid
[/Quote]
汗，分组查啊

[moleny]

order by groupid

[gogodiy]

用STUFF函数

[gogodiy]

select a.groupid,STUFF((select ';'+cellphone from mdao_member where groupid=a.groupid for xml path('')),1,1,'') as cellphone
from mdao_member as a where a.accountid = ? group by a.groupid

[风中云]

[Quote=引用 9 楼 gogodiy 的回复:]
SQL code


select a.groupid,STUFF((select ';'+cellphone from mdao_member where groupid=a.groupid for xml path('')),1,1,'') as cellphone
from mdao_member as a where a.accountid = ? group by a.group……
[/Quote]
不是很懂，没用过这个stuff函数，报错了，说xml附近有错误

[xiaoxiangqing]

select cellphone,count(*) from mdao_member where accountid = ? group by groupid