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