What is the SQL ROWNUM equivalent in HANA SQL script

[former_member233898]

Hi,

Could any one let me know what is the ROWNUM equivalent in HANA? Thanks for the help.

Thanks,

Jyothirmayi

[former_member182302 · Accepted solution]

Use window functions to generate the row number to use

Regards,

Krishna Tangudu

[former_member186082]

Hi Jyothirmayi,

ROW_NUMBER() OVER (ORDER BY <FIELD LIST>) is the function to generate row numbers.

ORDER BY clause is mandatory to generate row numbers in HANA.

Regards,
Chandra.