[SQL] 중복되는 값 가져오기
2014. 7. 7. 17:39ㆍDB/SQL
SELECT COLUMN_NAME
FROM TABLE_NAME
GROUP BY COLUMN_NAME HAVING COUNT(COLUMN_NAME) > 1
반응형
2014. 7. 7. 17:39ㆍDB/SQL
SELECT COLUMN_NAME
FROM TABLE_NAME
GROUP BY COLUMN_NAME HAVING COUNT(COLUMN_NAME) > 1