Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Randomizing output

Status
Not open for further replies.
emre

emre

IS-IT--Management
Dec 19, 2001
3
TR
How can I get the result set of a view sorted in a random fashion (each time I select, not only for once).
 
Sort by date Sort by votes
There is no ANSI SQL way of doing this. Some databases have a random function as an extension - your best bet is probably to post this question in the forum for the specific database you are using. Malcolm Wynden
I'm for sale at malcolm@wynden.net
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tekpr00
  • Locked
  • Question
Not getting the desired output
Replies
1
Views
97
r937
r937
soushi01
  • Locked
  • Question
Nested Select statement (error output) 1
Replies
2
Views
115
soushi01
soushi01
clone45
  • Locked
  • Question
SQL query with results formatted for table output?
Replies
6
Views
88
r937
r937
govmule
  • Locked
  • Question
Add Test Field To Output
Replies
1
Views
32
PHV
PHV
Sniipe
  • Locked
  • Question
sql output print statement
Replies
2
Views
44
Sniipe
Sniipe

Part and Inventory Search

Sponsor

Back
Top