아래의 쿼리를 돌리면 too many value 가 나오네요.
왜그런건지 모르겠어요.
where Rnum in (1,3,5,7,9) 하면 문제가 없는데 말이죠.
SELECT * FROM (
SELECT ROWNUM AS Rnum, b.*
FROM
( SELECT a.*
FROM USER_PROFILE a,
USER_SETTINGS b
WHERE a.UUID = b.UUID
AND b.sub_category = 001
AND b.set_param1 = 001
AND a.POPULATION > 50
ORDER BY a.population DESC
) b
WHERE ROWNUM < 50
) C
where Rnum in (
SELECT
ROUND(DBMS_RANDOM.VALUE(1, 5),0),
ROUND(DBMS_RANDOM.VALUE(6, 10),0),
ROUND(DBMS_RANDOM.VALUE(11, 15),0),
ROUND(DBMS_RANDOM.VALUE(16, 20),0),
ROUND(DBMS_RANDOM.VALUE(21, 25),0)
FROM DUAL ) |