5 pts.
 Random values selection
how i can select random values from a coloumn from a given table

Software/Hardware used:
ASKED: November 22, 2008  5:12 AM
UPDATED: November 25, 2008  10:37 PM

Answer Wiki:
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 Wiki Answer Submitted:  November 25, 2008  10:37 pm  by  SbElectric   2,510 pts.
All Answer Wiki Contributors:  SbElectric   2,510 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

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

 56,975 pts.

 

Yes, please provide more details, as this could probably be done in different ways depending on the database.

 63,535 pts.