查询某字段中数据重复的记录

SELECT * FROM  tablename WHERE ENTRY_ID IN ( SELECT ENTRY_ID FROM tablename GROUP BY ENTRY_ID HAVING COUNT(*)>1)

或者

select * from tablename t1 where  exists (select 1 from tablename t2
where t1.ENTRY_ID =t2.ENTRY_ID  and t1.rowid<>t2.rowid)