假设表名:e_custom
相同记录的字段:usn
select * from e_custom
where usn in (select usn from e_custom group by usn having count(*)>1)
假设表名:e_custom
相同记录的字段:usn
select * from e_custom
where usn in (select usn from e_custom group by usn having count(*)>1)
转载于:https://www.cnblogs.com/missthe/archive/2008/10/06/1305023.html