SELECT * FROM ( SELECT A.*, ROWNUM num FROM (SELECT * FROM TABLE_NAME) A WHERE ROWNUM <=10 ) WHERE num>=1