SELECT SUM () - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

SELECT SUM ()

Author

Topic

spoutnick
Starting Member

6 Posts

Posted - 2011-08-05 : 07:47:40

HELLO ALL,
I HAVE A TABLE THAT CONTAINTS INFORMATION LIKE THIS :
COL1 COL2 COL3 COL4
A1 001 FAC 200
A2 001 FAC 300
A3 001 FAC 2
A4 001 AVO 67
A5 002 FAC 40
A6 002 FAC 288
A7 002 AVO 20

I WOULD LIKE TO USE FUNCTION ((SUM(COL4) WHERE COL3=FAC)-(SUM(COL4) WHERE COL3=avo)) AND GROUP BY COL2

THANKS IN ADVANCE

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2011-08-05 : 08:18:41

SELECT Col2, SUM(CASE WHEN Col3 = 'Fac' THEN Col4 ELSE 0 END) - SUM(CASE WHEN Col3 = 'Avo' THEN Col4 ELSE 0 END)
FROM dbo.Table1
GROUP BY Col2

N 56°04'39.26"
E 12°55'05.63"