MYSQL:
select * from tbl limit 100;
ORACLE:
select * from tbl where rownum<=100;
SQL SERVER:
select top 100 * from tbl
SYBASE:
SET ROWCOUNT N GOSELECT * FROM TABLE1
MYSQL:
select * from tbl limit 100;
ORACLE:
select * from tbl where rownum<=100;
SQL SERVER:
select top 100 * from tbl
SYBASE:
SET ROWCOUNT N GOSELECT * FROM TABLE1