Random number function?

Aster

Random number function?

I've tried several SQL functions (Rand, Random, etc.) but none are supported.

What I am trying to do is create random "non events" for customers to test an hypothesis I have.

2 REPLIES
Senior Apprentice

Re: Random number function?

When you're looking for some functionality you should check the manuals, in that case the SQL Functions and Operators :-)

There's a RANDOM(minval,maxval) function which returns a random integer between minval and maxval:

http://www.info.teradata.com/HTMLPubs/DB_TTU_14_10/index.html#page/SQL_Reference/B035_1145_112A/Arit...

Re: Random number function?

Thank you, Dieter.  I actually did find and try RANDOM and got an error message that the function did not exist.