All Forums Aster
mwelsh8713 2 posts Joined 06/14
15 Aug 2014
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.

dnoeth 4628 posts Joined 11/04
15 Aug 2014

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/Arithmetic.075.111.html

Dieter

mwelsh8713 2 posts Joined 06/14
15 Aug 2014

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

You must sign in to leave a comment.