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