SELECT NAME FROM PRODUCT WHERE PRICE = (SELECT MAX(PRICE) FROM PRODUCT);
SELECT * FROM PRODUCT WHERE MADE = (SELECT MAX(MADE) FROM PRODUCT);
SELECT PRODUCT.*, ROWNUM FROM PRODUCT ORDER BY MADE DESC;
→ ORDER BY 전에 ROWNUM을 정해져, ROWNUM도 ORDER 된다.
SELECT TMP.* FROM (
SELECT * FROM PRODUCT ORDER BY MADE DESC
) TMP WHERE ROWNUM BETWEEN 2 AND 10;
→ ROWNUM을 2부터 reference로 설정되어 있어, 데이터 ROWNUM을 조사할 때 모든 행이 차례로 1로 인식되어 사라짐
SELECT * FROM (
SELECT TMP.*, ROWNUM AS RN FROM (
SELECT * FROM PRODUCT ORDER BY MADE DESC
) TMP
) WHERE RN = 1;
SELECT * FROM (
SELECT TMP.*, ROWNUM AS RN FROM (
SELECT * FROM MEMBER ORDER BY MEMBER_JOIN DESC
) TMP
) WHERE RN BETWEEN page AND size;