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!

How to select a value of a max value of another column in the same row?

tcodeJan 10 2012 — edited Jan 11 2012

pversion pdate pcount
1 11/6/2011 1
0 11/6/2011 25
1 11/6/2011 24

How to select pversion for a maximum pcount, in this case max count is 25 and version will be 0?

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 8 2012

Added on Jan 10 2012

#function, #query, #sql

4 comments

3,879 views