Sum of some Columns

[amerbaig]

I have a table with two columns

CustomerId ---- Varchar
Order_Amount ----- Integer

Now data is

Customer Order_Amount
Riz 100
Biz 200
Ciz 300
Tiz 400
Hiz 500
Uiz 600

I want to get rows whoses sum of order_amount is 500

Please help me out


Regards,

Amer

 

[Shantha]

select customerId from <table>
group by customerId having sum(order_amount) = 500

Hope it helps.

Shantha. Talent is what you possess;
genius is what possesses you

 

[amerbaig]

Output sould be

Result 1

Customer Order_Amount
Riz 100
Tiz 400

Result 2

Customer Order_Amount
Biz 200
Ciz 300


I need both output as one output.

 

[carp]

This is similar to another recent post. I don't think you can do this with SQL; it's going to take a fair amount of looping to do this so I think you'll need to use a procedural language like PL/SQL.