汇总查询不允许使用通配符*，但你可以把所有字段都选上再归类。SELECT ID, NAME, AGE, NUM, ADDR, Count(Table1.ID) AS Num数量FROM TableGROUP BY ID, NAME, AGE, NUM, ADDR
