By taking 2 seconds to use Google http://www.google.co.uk/search?hl=en&q=select+random+rows+%2B+SQL&btnG=Googl e+Search&meta=
"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: srinivas ganta To: CF-Talk Sent: Thu Mar 22 07:10:47 2007 Subject: Re: How to Random Pick records from a 10k record table via SQL Hi Michel, try the following query,i think this will help you. select * from myTable order by rand() limit 20; Thanks Srinivas On 3/22/07, Michael E. Carluen <[EMAIL PROTECTED]> wrote: > > Hello All, > > I am wondering how to randomly pick any 20 records from a table of 10,000+ > records, directly from a cfquery? Currently using mySQL. > > Any suggestions will be appreciated. > > Michael > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273345 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
