DB2 select * from table fetch first 100 rows only Informix select first 100 * from table Microsoft SQL Server and Access select top 100 * from table MySQL and PostgreSQL select * from table limit 100 Oracle 8i select * from (select * from table) where rownum <= 100
$query = mssql_query("SELECT * FROM USER LIMIT 0,100",$cid); ==> $query = mssql_query("SELECT TOP 100 * FROM USER",$cid);
Informix select first 100 * from table
Microsoft SQL Server and Access select top 100 * from table
MySQL and PostgreSQL select * from table limit 100
Oracle 8i select * from (select * from table) where rownum <= 100
==>
$query = mssql_query("SELECT TOP 100 * FROM USER",$cid);