SQL프로그래밍

오라클 SQL 상위 하위 10% 뽑아내기

노마드선샤인 2020. 8. 28. 18:23
728x90

WITH temp AS (
SELECT LEVEL AS grd
, COUNT(*) OVER() * 0.1 AS rate
, RANK() OVER (ORDER BY LEVEL DESC) AS f_rnk
, RANK() OVER (ORDER BY LEVEL ASC) AS l_rnk
FROM dual
connect BY LEVEL < 101
)
SELECT grd, rate, f_rnk, l_rnk
FROM temp
WHERE f_rnk <= rate
OR l_rnk <= rate

728x90