从SQL SUM查询中排除某些字段 [英] Excluding certain fields from an SQL SUM query

问题描述

我正在通过SQL使用以下SUM查询

I am using the following SUM query with SQL

SELECT SUM(cost) as total FROM sales where passport =

我如何从计算中排除某些记录，例如，其中薪金= 1?

How would I exclude certain records from the calculation, for example where paid = 1?

推荐答案

简单

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

这篇关于从SQL SUM查询中排除某些字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！