mysql - 选择除当前月份mysql之外的所有数据

Question

我想获得除当前月份以外的所有金额的总和。在 WHERE 之后我应该写什么？

SELECT SUM(amount) FROM transactions WHERE ...

标签： mysqldatabase

Answer 1

SELECT SUM(amount) FROM transactions WHERE month != "July";

https://docs.microsoft.com/en-us/sql/t-sql/language-elements/not-equal-to-transact-sql-exclamation?view=sql-server-ver15