PostgreSQL
select * from table limit 10 offset 0;
Oracle
select * from table where rownum <= 10;
Mysql
select * from table limit 0,10
select * from table limit 10 offset 0;
select * from table where rownum <= 10;
select * from table limit 0,10