IBM Maximo Implementation and Configurations
https://maximodeploy.blogspot.com
Pages
Home
Application Designer
Automation Scripts
Useful Resources
Linux
Oracle
Networks
About Us
Top Navigation
Showing posts with label
row_number
.
Show all posts
Showing posts with label
row_number
.
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.
Read more »
Older Posts
Home
Subscribe to:
Posts (Atom)