Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Find the max value for each distinct value of an emp

user10400721May 11 2014 — edited May 11 2014

I have a table of below structure/data. I need to find out the Each sal_type with highest version number  for each id (Expected Answer--> Rows marked in Red)

IDSal_TypeVersion
1bonus1
1bonus2
1bonus3
1perk1
1perk2
2bonus1
2bonus2
2perk1
2perk2
2perk3
2perk4
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 8 2014
Added on May 11 2014
#in, #value
4 comments
985 views