HOW TO USE SUM FUNCTION INSIDE A SELECT

Question

Hello,

I am trying to sum the debits columns and credit columns so I wrote: but is not working I dont get the debit column 

    

select   C.code_id,C.AMOUNT,C.BALANCE_AMOUNT,

(SELECT (case when C.BALANCE_AMOUNT > 0 then C.BALANCE_AMOUNT else 0 end) as debits )

from charge C

group by  C.code_id, C.AMOUNT, C.BALANCE_AMOUNT

Answer 1

Can you please provide input (as create table and insert statements) and the desired output? I can not figure from the query you posted what do you actually want.

Most likely your query needs to be

select   C.code_id, C.AMOUNT, 
SUM (case when C.BALANCE_AMOUNT < 0 then C.BALANCE_AMOUNT else 0 end) as Credits, 

SUM (case when C.BALANCE_AMOUNT > 0 then C.BALANCE_AMOUNT else 0 end) as Debits 

from charge C

group by  C.code_id, C.AMOUNT

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

My TechNet articles

Answer 2

Hi Ysabel1111

Could you please share us  your table structure (CREATE TABLE …) and some sample data(INSERT INTO …)
 along with your expected result? So that we’ll get a right direction and make some test.

Please try :

select   C.code_id,C.AMOUNT,C.BALANCE_AMOUNT,

sum(case when C.BALANCE_AMOUNT > 0 then C.BALANCE_AMOUNT else 0 end) as debits 

from charge C

group by  C.code_id, C.AMOUNT, C.BALANCE_AMOUNT

Best Regards 
Echo

---

""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
For more information, please refer to the sticky post.

Answer 3

Thank you it works!!