select b,count(*) as 数量 from 表A group by b
select b,count(*) as '相同字符串数量' from A group by b
select A.b,COUNT(*) from A group by b
SQL语句:select b + '='+ convert(varchar(50),count(1)) from A group by b
select count(*) from A GROUP BY 字段名