Random values selection
Home > IT Answers > Development > Random values selection
Kamboj
5 pts.
0
Q:
Random values selection
Database programming, tables
how i can select random values from a coloumn from a given table
ASKED: Nov 22 2008  5:12 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
SbElectric
1625 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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.
Last Answered: Nov 25 2008  10:37 PM GMT by SbElectric   1625 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Technochic   40210 pts.  |   Nov 22 2008  6:16PM GMT

Can you tell us what application and version you are using please?

 

Carlosdl   29855 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.

 
0