PostgreSQL

select * from table limit 10 offset 0;

Oracle

select * from table where rownum <= 10;

Mysql

select * from table limit 0,10