How can I achieve the same effect as ROW_NUMBER when using pagination?
I want to add count of rows per group of one of the columns. It works fine with regular queries, but not with pagination because each page starts the count from 0.
I want to add count of rows per group of one of the columns. It works fine with regular queries, but not with pagination because each page starts the count from 0.