I am using the following SUM query with SQL
SELECT SUM(cost) as total FROM sales where passport =
How would I exclude certain records from the calculation, for example where paid = 1?
views:
46answers:
5
A:
Hi,
Do you mean like this ?
SELECT SUM(cost) as total FROM sales where (passport = $myPassport AND paid <> 1)
Trefex
2010-07-06 09:05:26
*excluding* where paid = 1...
CJM
2010-07-06 09:07:13
Yes yes, already corrected it...Gimme a chance instead of downvoting me :( :)
Trefex
2010-07-06 09:07:36
A:
SELECT SUM(cost) as total FROM sales where passport = "12345" and paid <> 1
peter_mcc
2010-07-06 09:05:42
A:
SELECT SUM(cost) as total
FROM sales
WHERE passport = 12345
AND paid <> 1
CJM
2010-07-06 09:05:58
+1
A:
Simply
SELECT SUM(cost) as total
FROM sales
WHERE passport = ?
AND paid <> 1
You may also be looking for a group by here
SELECT passport, SUM(cost) as total
FROM sales
WHERE passport = ?
AND paid <> 1
GROUP BY passport
Cruachan
2010-07-06 09:06:10
A:
did you mean to get only total that equal to 1 ?
USE : HAVING total = 1
Haim Evgi
2010-07-06 09:06:34