select name, count(name) from student group by name having count(name)>1 经常会遇到这样的问题,其实主要就是考察 gruop by 和having 的组合用法!