一个简单的问题，第一个正确答案得分

[hongyan80]

表
GYH ZY
------ -----
T111 AB
T222 CC
T111 DD
T111 EF
T333 FF
T333 FD
怎样查每个GY有几条？

[sdhdy]

select GYH,count(ZY) as 条数 from tablename group by GYH

[txlicenhe]

楼主写错了，不知是哪一个
select GYH,count(*) as cnt from 表 group by GYH

还是
Select ZY,count(*) as cnt from 表 group by ZY

[RockEx]

根据GYH字段分组

select gyh ,count(zy) from tablename group by gyh

[gmlxf]

select GYH,count(*) 条数 from 表 group by GYH