Skip to Content

Row_Number() in a query

To count the line in a query, use row_number(). The keyword partition allow to reset the counter:

example:

Capture.JPG

You have to use convert as row_number() is a bigint in SQL and SAP doesn’t handdle this type of value.

Be the first to leave a comment
You must be Logged on to comment or reply to a post.