Database SQL Syntax
- Different databases using different sql statement
DB2
select * from table fetch first 10 rows only
Informix
select first 10 * from table
Microsoft SQL Server and Access
select top 10 * from table
MySQL and PostgreSQL
select * from table limit 10
Oracle 8i
select * from (select * from table) where rownum <= 10
