摘要: 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... 阅读全文
posted @ 2008-07-11 10:04 Liran 阅读(208) 评论(0) 推荐(0)