ROWNUM, 행 제한

- ROWNUM

 

SELECT * FROM (SELECT ROWNUM, MEMBERS.* FROM MEMBERS)

WHERE ROWNUM BETWEEN 1 AND 5

 

- 중복 값 제거

 

SELECT DISTINCT AGE FROM MEMBERS