SQL sum function with where clause

Question

I am using MsSQL and I want to add some values where some conditions are met. Is it possible to use WHERE clause in the sum() function? Or is there an equivalent function to the excel SUMIF().

Post your query and we can help.

Jon Crowell
– Jon Crowell

2012-05-16 15:36:07 +00:00
Commented May 16, 2012 at 15:36 — Jon Crowell
– Jon Crowell, Commented May 16, 2012 at 15:36

Oded · Accepted Answer · 2012-05-16 15:35:35Z

2

The SUM aggregate will only operate on the result set constrained by the WHERE clause.

In other words, yes, this is fine.

SELECT SUM(days)
FROM myTable
WHERE something = another

answered May 16, 2012 at 15:35

Oded

501k102 gold badges900 silver badges1k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Metta Over a year ago

sorry I didn't explain but I don't to use the condition in the where clause

Oded Over a year ago

@Mhretabk - Well, where are you using a condition then? Posting the query in your question would have left no doubt.

Tim Schmelter · Accepted Answer · 2012-05-16 15:37:06Z

1

You could use CASE:

SELECT SUM(CASE WHEN YourCondition=1 THEN 1 ELSE 0 END)
FROM YourTable

answered May 16, 2012 at 15:37

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

1 Comment

bendataclear Over a year ago

+1 over Oded's method, this allows you to group the results which (I guess) would be more useful to the OP.

Collectives™ on Stack Overflow

SQL sum function with where clause

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related