SUM that filters out data

Question

Hi

I want to sum some data, where it is not a certain value. For example I can do this for everything;

SUM(Profits)

However I want to do something like this

SUM(Profits) where not internal

How can I do this? sorry most likely a dumb question

Answer 1

use CASE WHEN inside

ie like below

SUM(CASE WHEN Internal=0 THEN Profits ELSE 0 END) 

assuming internal is a bit field

if not just write appropriate condition within WHEN

---

Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

Answer 2

A query like this is perfectly valid:

SELECT SUM(Profits)
FROM my_table
WHERE internal='no'

---

Gert-Jan