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: 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. ********************************************************************** -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
