Skip to Content
Jul 05, 2018 at 12:33 PM

How do I generate random numbers in Hana Studio select statement



I would like to generate random numbers between 1 and 20 in a select statement in Hana Studio. The person holding the random number generated by the system will perform a task.

select 'Selected Person' As "Statement", Random(1,20) from dummy;

select 'Selected Person' As "Statement", Rand() from dummy; -- not required as it generates numbers between 0 and 1.

Thanks in advance