cancel
Showing results for 
Search instead for 
Did you mean: 
Subscribe

Hi dear colleagues , My report starts counting rows from 3-rd , how i can fix it? maybe with some formula?

Thanks in advance !

0 Likes
View Entire Topic
ThorstenHoefer
Active Contributor

Hi Nizam,

to determine the row number in HANA, you can use sql like this:

select ROW_NUMBER() OVER (ORDER BY table_name ) as no, table_name  from tables