Another Random Record Selection Method

By Bill Graziano on 6 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.

If you like this article you can sign up for our weekly newsletter. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Related Articles

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)

Other Recent Forum Posts

re-added user but cannot assign User Mapping (0 Replies)

Compare Count left join (7 Replies)

rows to columns (6 Replies)

Data Comparision (1 Reply)

sum qty's in one table, join on the other (2 Replies)

SQL Server 2008 querying Active Directory (8 Replies)

Excel Data to SQL Server table (1 Reply)

Dynamic view (4 Replies)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -