Random values selection

5 pts.
Tags:
Database programming
tables
how i can select random values from a coloumn from a given table

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Technochic
    Can you tell us what application and version you are using please?
    57,010 pointsBadges:
    report
  • carlosdl
    Yes, please provide more details, as this could probably be done in different ways depending on the database.
    78,735 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: