How to generate a random numbers in a range of values in db2.
I tried I can specify the upper limit , i can't specify the lower limit. I want to generate the random numbers between 1 to 10.
can some one tel me how to work.
This is what I tried:
SELECT CAST ( int ( RAND () * LENGTH(109)) AS CHAR(1)) FROM SYSIBM.SYSDUMMY1);