Random values selection
Database programming, tables
how i can select random values from a coloumn from a given table Question
Database programming, tables
how i can select random values from a coloumn from a given table 
Subscribe to Alerts! Get questions and answers delivered to your Inbox.
Answer Wiki (Improve, edit or add to this answer)
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
If it is Excel - do you know the start and end row number of the column? Then you can set up Random number generator: =TRUNC(RAND()*(High-Low)+Low) Note: Low & High are the column row references.
You now may use this number as the random row number & get the corresponding value.
Browse more Questions and Answers on Development and Database.
Looking for relevant Development Whitepapers? Visit the SearchWinDevelopment.com Research Library.
Discuss This Answer
You must be logged-in to discuss a question. Log-in/Register
Technochic 
35525 pts. | Nov 22 2008 6:16PM GMT
Can you tell us what application and version you are using please?
Carlosdl 21920 pts. | Nov 24 2008 2:33PM GMT
Yes, please provide more details, as this could probably be done in different ways depending on the database.
