Dear Forum:
I have a Column1 that has values from 1 - 9. I need to Sum the values of this column for each value (1 through 9) when Column2 = '1'
So I the results would be:
1 = 23
2 = 43
3 = 96
.....
Would appreciate some help on how to accomplish this.
SELECT
SUM(CASE WHEN COLUUMN1 = 1 THE COLUMN1 ELSE 0 END),
SUM(CASE WHEN COLUUMN1 = 2 THE COLUMN1 ELSE 0 END),
And so forth
FROM YourTable
WHERE Column2 = 1
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
February 24, 2020 at 7:32 pm
SELECT Column1, COUNT(*) * Column1 AS SumColumn1
FROM dbo.table_name
WHERE Column2 = '1'
GROUP BY Column1
ORDER BY Column1
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply