Re: Stochastic Queries

From: Joe Thurbon <usenet_at_thurbon.com>
Date: Mon, 10 Sep 2007 20:58:55 GMT
Message-ID: <jeiFi.33699$4A1.17347@news-server.bigpond.net.au>

Jason Lepack wrote:
> It depends... I don't know of any "good" methods using ANSI SQL, but
> there are methods that can be used depending on what type of SQL you
> are using.
>
> Try google... I found all of these solutions by typing into Google:
> "language-name" random records
>
> In T-SQL there's the newid() method:
> http://www.sqlteam.com/article/using-newid-to-randomly-sort-records
>
> Oracle has sample():
> http://www.adp-gmbh.ch/ora/sql/examples/select_sample.html
>
> MySQL has rand():
> http://webxadmin.free.fr/article/mysql-random-records-170.php
>
> Cheers,
> Jason Lepack
>

Thanks Jason,

I'll look into it.

Cheers,
Joe Received on Mon Sep 10 2007 - 15:58:55 CDT