Re: SQL to select a set of records

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> 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


-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux