Categories Uncategorized Row_Number() in a query November 10, 2014 | 20 Views | Former Member Retagging required christophe averous s blog share share tweet share Follow To count the line in a query, use row_number(). The keyword partition allow to reset the counter: example: You have to use convert as row_number() is a bigint in SQL and SAP doesn’t handdle this type of value. Alert Moderator To report this post you need to login first. Add a Comment Be the first to leave a comment You must be Logged on to comment or reply to a post. Leave a Reply Cancel replyYou must be logged in to post a comment.