SELECT * FROM ( SELECT ROW_NUMBER() OVER (PARTITION BY [컬럼1] ORDER BY [컬럼1]) AS num, * FROM [테이블명] ) A WHERE A.num > 1;