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!

How extract several Max(amount) 's with sql

Cac47Jun 20 2013 — edited Jun 20 2013

Hi there

I've this issue,

I hace this Table

DISPLAY_NAME,              MSISDN        TRANSACTIONS

------------------------- ------------------- ------------

CM, SA - MERCHANT I       829882904                     75

CM, SA - MERCHANT I       827102931                     43

CM, SA - MERCHANT I       824034968                     17

CM, SA - MERCHANT II      827102931                     48

4 rows selected.

And I need to get the records corresponding to the highest trasactions per DISPLAY_NAME

The Resulet Should Be something like

DISPLAY_NAME,              MSISDN        TRANSACTIONS

------------------------- ------------------- ------------

CM, SA - MERCHANT I       829882904                     75

CM, SA - MERCHANT II      827102931                     48

Any Ideas?

Txs if you can help
This post has been answered by Frank Kulash on Jun 20 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 18 2013
Added on Jun 20 2013
2 comments
132 views