Question

Asked:
Asked By:
Nov 22 2008   5:12 AM GMT
Kamboj   5 pts.

Random values selection


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.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
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.
  • AddThis Social Bookmark Button

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.