RE: [PHP-WIN] SQL to select a set of records
| From: | David Felton | Date: | Fri, 06 Feb 2004 11:33:52 +0000 |
| Subject: | RE: [PHP-WIN] SQL to select a set of records | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-22744@lists.php.net to get a copy of this message | ||
No it doesn't. you'll need to do something like this in MS-SQL (using a
sub-select):
SELECT TOP 10 dbo.Table_MIS_Files.File_ID
FROM dbo.Table_MIS_Files
WHERE dbo.Table_MIS_Files.File_ID NOT IN
(SELECT TOP 25 dbo.Table_MIS_Files.File_ID
FROM dbo.Table_MIS_Files)
-----Original Message-----
From: Nadim Attari [mailto:nadim@alienworkers.com]
Sent: 06 February 2004 11:33
To: php-windows@lists.php.net
Subject: Re: [PHP-WIN] SQL to select a set of records
> 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
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
**********************************************************************