When the results are displayed across pages and say you are on nth page and try to sort on a column, should it remain on the same nth page or should it display the first page? If it can be either, are there use cases/specific kind of data when it would be ideal to stay on the current page upon sorting vs. navigate back to the first page?
You should navigate back to the first page. To understand why, you should simply answer the question why user sort lists. For example they want to :
- find the highest score
- start reviewing products starting from the lowest price
- find the most recent posts
- find the employee name starting with the letter B
- find the e-mails send on the 5th of December
In all of the above cases, the most useful behavior would be to navigate back to the first page.