SQL查询重复记录

例：

 

select * from employee
where emp_name in (select emp_name from employee group by emp_name having count(emp_name) > 1)