SELECT Left(表名.[姓名], 1) as 家姓,count(Left(表名.[姓名], 1)) as 人数 FROM [表名] group by Left(表名.[姓名], 1);
select name, count(1) num from (select left(name, 1) name from tableName) a where group by name
