SqlServer select top 10 * from tablename; Informix select first 10 * from tablename; Oralce select * from tablename where rownum<=10; MySql & sqlite select * from tableName limit 10