Oracle 에서 Limit

SELECT * FROM (SELECT * FROM DIST_TABLE ORDER BY IDX DESC) WHERE ROWNUM <= 10;


http://www.oracle.com/technology/global/kr/oramag/oracle/06-sep/o56asktom.html