how can i generate n unique random numbers in sybase

Question

i need to generate n unique random numbers in sybase ase. The number n will be specified while executing the required stored proc.. ex : exec procedurename 12 should return 12 unique random numbers.

Is there a way to do this in sybase ase?

Thanks rinu

score 0 · Accepted Answer · answered Jul 25 '13 at 13:33

0

rand() and rand2() are the built in random number functions for SAP Sybase ASE.

More information on these and other functions can be found here:

Reference Manual:Building Blocks

answered Jul 25 '13 at 13:33

Mike Gardner

6,611
5
24
34

needed integers ..got it with this : round((RAND() * (10^100)),0) – doubting Jul 25 '13 at 15:03
Many random fuctions return a value between 0 and 1, and it is then up to the developer to decide how to satisfty their requirements. – Mike Gardner Jul 25 '13 at 16:15

how can i generate n unique random numbers in sybase

1 Answers1