在mysql中可以用group by对查询出的数据分组
select id,service,name FROM service GROUP BY name,service
如果要查看每组数据的总数,可以
select count(*) FROM service GROUP BY name,service
当要查询group by后的总数,可以这样
select count(*) from(select count(*) FROM service GROUP BY name,service) s