MSSQL
SELECT top 10 * FROM table1
ORACLE
SELECT * FROM table1 WHERE rownum<10
Postgre
SELECT * FROM table limit 10
MSSQL
SELECT top 10 * FROM table1
ORACLE
SELECT * FROM table1 WHERE rownum<10
Postgre
SELECT * FROM table limit 10