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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Aggregating rows to form a report

The_Cute_DBAMay 25 2022

Hello Experts,
How can I aggregate this CUSTOMERS table data using SQL code:

CustomerName CustomerID Amount
Maria         101        25
Maria         101        35
Maria         101        45
John          202        10
John          202        10
John          202        10
James         303        70

To make it look like this:

CustomerName CustomerID Amount
Maria          101       105
John           202       30
James          303       70
This post has been answered by Frank Kulash on May 25 2022
Jump to Answer

Comments

Post Details

Added on May 25 2022
4 comments
64 views