Do you need every 10th row, or do you need it random? Because they are two different things. Choosing every 10th row isn't any more random than choosing the first 16600 records.
> I don't need the first 16600. > I need to choose randomly. > > in more easy way every 10th row. (or randomly 16600) > > > > > >SELECT FIRST 16600 * FROM TABLE > > > > > >> The situation is I have 166000 records. > >> > >> I need to select 10% of it. i.e. every 10th row. > >> And I need to select 10% and thats it. after that I don't need this field > >anymore. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185045 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
