现在一用户表`user`,数据如下:
1.查出名称`name`重复的记录
mysql> select name, count(*) as name_count from user group by name having name_count > 1;
2.查出年龄`age`大于1,名称`name`有多少种情况,分组:
mysql> select age, name, count(*) as cnt from user where age > 1 group by name;
3.查出年龄`age`大于1,名称`name`重复的记录
mysql> select age, name, count(*) as cnt from user where age > 1 group by name having cnt > 1;
...