sql - 运行联合查询时，')' 附近的语法不正确

Question

尝试运行此联合查询并在 ')' 错误附近不断收到不正确的语法。

SELECT ACCOUNT_ID, count(*)
AS TOTAL_TRANSACTIONS
FROM ACCOUNT_TRANSACTION
WHERE TRANSACTION_TYPE_ID = '9'
GROUP BY ACCOUNT_ID
HAVING COUNT(*) < '4'
UNION
SELECT TRANSACTION_STATUS_DATE
AS TRANS_DATE
FROM ACCOUNT_TRANSACTION
GROUP BY TRANSACTION_STATUS_DATE
HAVING (MONTH(TRANSACTION_STATUS_DATE) = MONTH(dateadd(dd, -1, GetDate()))
AND YEAR(TRANSACTION_STATUS_DATE) = YEAR(dateadd(dd, -1, GetDate())

标签： sqlsql-server

Answer 1

数一数你的括号。(afterHAVING没有匹配的).

此外，不适合 SO。