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 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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