Showing posts with label partition order. Show all posts
Showing posts with label partition order. Show all posts

Thursday, 12 September 2019

Top N rows in a group by using row_number function | SQL

Let say I have this below data in my table for instance:



and my desired output is as below: Group it by WONUM but also I want to see the 2 records of each group.