sql 查询一张表中除id以外重复的数据

select id from dc_entry_detail  a,(select source_id from  dc_entry_detail group by source_id having count(*) >1) b
      where a.source_id = b.source_id  
      and a.id in (select min(id) from dc_entry_detail where a.source_id = source_id)
      order by a.source_id

 

详解：select id from 表A a ，（select  表中任意一个等值字段c from 表A a group by 表中任意一个等值字段c having count(*)>1）b

where a.表中任意一个等值字段c=b.表中任意一个等值字段c

and a.id in (select min(id) from dc_entry_detail where a.表中任意一个等值字段c = 表中任意一个等值字段c)