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.