Skip to Main Content

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!

Query to display Max column value based on ID

srikanth bMar 20 2021

ID NAME AGE
1 John 25
1 Kelvin 29
1 Frank 30
2 Raj 33
2 Ashok 21
2 Lak 20

Expected output;

ID NAME AGE
1 Frank 30
2 Raj 33

This post has been answered by Frank Kulash on Mar 20 2021
Jump to Answer
Comments
Post Details
Added on Mar 20 2021
5 comments
504 views