- ORACLE
select * from table where rownum <= N;
- MySQL
select * from table limit N;
- SQL SERVER
select top N * from table;
- PostgreSQL
select * from table limit N;
- INFORMIX
select first N * from table;
- DB2
select * from table fetch first N rows only;
- Other