SELECT * FROM table WHERE ROWNUM < 10;