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!

Group by- Max values+equal values

Bharat_HegdeMar 28 2013 — edited Mar 28 2013

Hi Experts,

I am looking for a query where i can group the data accordingly and exclude the rows which i don't need.please help to arrive this.
i have the data like this in my table

Cust_id type count
10 abc 19
10 abcde 19
10 abcde 8
20 e 8
20 u 4
30 f 30

I need the out put like this
Cust_id type count
10 abc 19
10 abcde 19
20 e 8
30 f 30

Thanks
Bharat

This post has been answered by Ramin Hashimzadeh on Mar 28 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 25 2013

Added on Mar 28 2013

#sql

14 comments

164 views