Re: How to Random Pick records from a 10k record table via SQL

[srinivas ganta]

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
>
>
>
> 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273343
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4