| | Submitted on: 5/27/2003 8:25:47 PM
By: John Cappelletti
Level: Advanced User Rating:
By 4 Users Compatibility:SQL Server 2000, SQL Server 7.0
Users have accessed this article 3068 times. | |
| | A very simple technique to select random data from a SQL Server query | |
|
Terms of Agreement:
By using this article, you agree to the following terms...
1) You may use
this article in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
2) You MAY NOT redistribute this article (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
3) You may link to this article from another website, but ONLY if it is not wrapped in a frame.
4) You will abide by any additional copyright restrictions which the author may have placed in the article or article's description. | To select random rows of data via a query, try the following:
Select Top 10 * from myTable Order By NewID()
The key here is the NewID() function which returns a random unique
identifier.
| |
Other 3 submission(s) by this author
|
|
|
Report Bad Submission |
|
|
Your Vote! |
See Voting Log |
|
Other User Comments |
5/28/2003 8:11:35 AM:Sean P. O. MacCath-Moran Ok… well… *thumps himself on the head*
That seems so obvious now that you said
it, eh? VERY nice coding approach! I
can't think of an immediate use for it,
but I'm going to tuck that away in my
'Nifty Tricks' file for when I do! =o)
Thanks for the post!
|
5/28/2003 9:38:33 AM: I have a list of resources persons in
an ASP page for which it's sad to list
in alphabetical order (because the A
ones are always listed first, etc.).
With this quasi-random way, my problem
is solved without VBScript processing!
Thankx! Very useful!
|
6/9/2003 10:06:38 AM: i find this article very useful, thx
|
6/26/2003 2:48:10 AM: i want to do it in Access,
Could you
help me?
From Korea,South
|
10/30/2003 9:33:54 AM:David Longley I like it!
|
10/30/2003 3:55:21 PM: dude......your one line takes my 5
globsssssss
|
|
Add Your Feedback! |
Note:Not only will your feedback be posted, but an email will be sent to the code's author in your name.
NOTICE: The author of this article has been kind enough to share it with you. If you have a criticism, please state it politely or it will be deleted.
For feedback not related to this particular article, please click here. |
|