Re: SQL to select a set of records
| From: | Stuart | Date: | Fri, 06 Feb 2004 12:44:30 +0000 |
| Subject: | Re: SQL to select a set of records | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-22745@lists.php.net to get a copy of this message | ||
David Felton wrote:
SELECT TOP 10 dbo.Table_MIS_Files.File_ID FROM dbo.Table_MIS_FilesShouldn't this be... SELECT TOP 25 dbo.Table_MIS_Files.File_ID FROM dbo.Table_MIS_FilesWHERE dbo.Table_MIS_Files.File_ID NOT IN (SELECT TOP 25 dbo.Table_MIS_Files.File_IDFROM dbo.Table_MIS_Files)
WHERE dbo.Table_MIS_Files.File_ID NOT IN(SELECT TOP 10 dbo.Table_MIS_Files.File_ID FROM dbo.Table_MIS_Files) That will get rows 11-25. -- Stuart