[ORACLE,CUBRID] 통계 데이터 뽑아오기 (상위RANK, 하위기타나눠서)

(
	select ALL_RANK, law_stblty_inftr , CNT FROM
	(
		SELECT rank() over (order by CNT desc) as ALL_RANK,LAW_STBLTY_INFTR, CNT FROM
		(
			SELECT LAW_STBLTY_INFTR, COUNT(LAW_STBLTY_INFTR) AS CNT
			FROM TB_PRVSN_EVL_RESULT 
			WHERE 1=1
				AND TO_CHAR(FRST_REG_DT, 'YYYY-MM') = TO_CHAR(SYS_DATETIME, 'YYYY-MM') 
				AND LAW_STBLTY_INFTR IS NOT NULL
			GROUP BY LAW_STBLTY_INFTR
		)
	)
	where ALL_RANK <= 3
)
union all
(
	select ALL_RANK, 'ETC' as ETC, SUM(CNT) FROM
	(
		select ALL_RANK, law_stblty_inftr , CNT FROM
		(
			SELECT rank() over (order by CNT desc) as ALL_RANK,LAW_STBLTY_INFTR, CNT FROM
			(
				SELECT LAW_STBLTY_INFTR, COUNT(LAW_STBLTY_INFTR) AS CNT
				FROM TB_PRVSN_EVL_RESULT 
				WHERE 1=1
					AND TO_CHAR(FRST_REG_DT, 'YYYY-MM') = TO_CHAR(SYS_DATETIME, 'YYYY-MM') 
					AND LAW_STBLTY_INFTR IS NOT NULL
				GROUP BY LAW_STBLTY_INFTR
			)
		)
		where ALL_RANK > 3
	)
	group by ETC
)

 

이렇게하면 COUNT 갯수가제일많은 상위3개 나오고 나머지는 기타로한번에 더해져서 값이추출됨