场景语句
1.一张表中有id和name 两个字段,查询出name重复的所有数据
select * from student a where (a.name) in (select name from student group by name having count(*) > 1)
考点:having count(*)>1
mysql知识
1.order by与group by的区别
order by:对查询结果的某一列或多列进行排序(ASC:升序;DESC:降序)
group by:对查询结果的某一列或多列进行分组,和聚合函数一起使用
注意:当group by和order by一起使用时,group by一定在order by的前面