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!

Distinct with max value

2896536Mar 12 2015 — edited Mar 12 2015

Hi Forum,

looking for help for my today´s problem. I need to select each distinct MNR holding the maximum value of WBZNEW.

This is a part of my table

MNR     ,WBZNEW,LZ,Ressource

11210009,    25,20, 7000381

11210009,    20,15, 7000658

11210011,    20,15, 7000359

11210011,    20,15, 7009123

11210011,    20,15, 7001327

11210012,    20,15, 7001327

11210012,    20,15, 7009123

11210018,    40,35, 7000324

11210018,    45,40, 7000381

11210027,    20,15, 7000324

11210027,    30,25, 7001683

11210027,    20,15, 7000378

thanks for your help

Heiko
This post has been answered by 2847291 on Mar 12 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 9 2015
Added on Mar 12 2015
6 comments
466 views