Re: SQL to select a set of records
| From: | Nadim Attari | Date: | Fri, 06 Feb 2004 11:32:32 +0000 |
| Subject: | Re: SQL to select a set of records | ||
| References: | 1 2 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-22742@lists.php.net to get a copy of this message | ||
> mysql> select * from table LIMIT 5,10; # Retrieve rows 6-15
> If one argument is given, it indicates the maximum number of rows to
return:
> mysql> select * from table LIMIT 5; # Retrieve first 5 rows
Dunno whether LIMIT works in Microsoft SQL Server ... someone may check it
plzzz
~nadim attari