关于Select count 请教

[cpuxpcn]

例
Select Shop_ProductsName,count(*) as sss from Tx_Shop group by Shop_ProductsName
这一句正常
但要可以查询 Tx_Shop表中的其他字段Shop_Pmoney，所有我这样写
Select Shop_ProductsName,count(*) as sss,Shop_Pmoney from Tx_Shop group by Shop_ProductsName
但不能执行

请教大侠们，在线等。。。

[子陌红尘]

Select
Shop_ProductsName,
count(*) as sss,
Shop_Pmoney
from
Tx_Shop
group by
Shop_ProductsName,
Shop_Pmoney --分组条件要在此列出

[CSDMN]

Select
Shop_ProductsName,
count(*) as sss,
min(Shop_Pmoney) as Shop_Pmoney --如果不能改分组，那只能改这里了
from
Tx_Shop
group by
Shop_ProductsName

[cpuxpcn]

ok了，谢谢大家，我想问你们是怎么知道的，好像sql帮助上没有说吧，还是我没有看到？