DBMS/DataBase
[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 ) group by ETC ) 이렇게하면 COUN..
