Skip to Content
0
Former Member
Jun 12, 2012 at 05:04 AM

Is there any function like rand() or newid() supported by HANA?

135 Views

Hi experts,

I'm doing a test to compare data fetched from HANA views with those directly fetched from ABAP table.

Can you please suggest, whether there is any function similar as rand() or newid(), which can get given number of random records.

----x----

select top N * from table_name order by newid()

----x----

Thanks a lot.