Another Random Record Selection Method

By Bill Graziano on 06 January 2002 | 0 Comments | Tags: Randomness

Dutch submitted "Yet an other method to random select a records from a database. However this method does not use a temporary table, which has a lot of overhead when you're dealing with large tables." Follow the link to Another Random Record Selection Method...

Discuss this article: 0 Comments so far. Print this Article. This page has been read 11,768 times.

If you like this article you can sign up for our newsletter. We send it out each week that we post a new article. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Email This • Subscribe to this feed • Kick it • Save to del.icio.us • View blog reactions

Using NEWID to Randomly Sort Records (16 April 2002)

Multiple Random Records w/Single Select (4 October 2000)

Returning a Single Random Row (27 September 2000)

Returning Rows in Random Order - Part III - Practical Applications (12 September 2000)

Returning Rows in Random Order - Part II - Revenge of the Randomizer (11 September 2000)