오라클 중복 레코드 검사 쿼리

By | 4월 2, 2012
0 Comment

SELECT COUNT(COL1),COL1
   FROM TABLE1 
GROUP BY COL1 HAVING COUNT(COL1) > 1;

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments