[oracle] 오라클 중복제거 하면서 전체 값 가져오기

SELECT *
FROM (
  SELECT 컬럼1, 컬럼2, 컬럼3,
               ROW_NUMBER() OVER( PARTITION BY 중복조회컬럼 ORDER BY 정렬컬럼 ) CNT
  FROM 테이블
  )
WHERE CNT > 1
RANK() OVER()
DENSE_RANK() OVER()

실무에 사용했던 예))

SELECT *
 FROM ( SELECT TEMP_TABLE.*,
   ROWNUM, FLOOR((ROWNUM-1) / 20) page
 FROM ( SELECT C.*, ROW_NUMBER() OVER( PARTITION BY GOODS_SEQ ORDER BY TAG_NUMBER DESC ) RN
  FROM goods_stock_view C
 WHERE 1=1 AND BUSINESS_OFFICE_SEQ = '31'
 )  TEMP_TABLE )
  WHERE RN = 1 AND page = 1 - 1