选择重复,消除重复和选择出序列 所有名字重复人的记录是: select * from emp where name in (select name from emp group by name having count(*)>1)