MS SQL select top 10 * from dual Oracle select * from dual where rownum < 10 MY SQL select * from dual limit 10