is there a limit function ins SQL Server 2000? -----Original Message----- From: Jesse Houwing [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 01, 2002 8:17 AM To: CF-Talk Subject: Re: Nth Record Selection Set
Jim Gurfein wrote: > Hi List, > > <Sorry for sending this again, but the list was having problems > > > All you gurus out there... I'm trying to find a way to select every nth > record from a database that has 200,000 records. How would I go about > setting up the SQL to select every 15th record ? > > Any and all help would be appreciated! In MySQL, PostgreSQL and such: SELECT * FROM table LIMIT startrow, numberofrows so the 15000th item en the 15 following it would be: SELECT * FROM table LIMIT 15000, 15 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists