SQL Query aggregate may not appear in WHERE clause
SQL Query aggregate may not appear in WHERE clause
错误的写法
SELECT StartDate,
ClientID,
COUNT(1) AS Total
FROM dbo.tbm_cti_CustomTableItem_BudgetPeriod
WHERE COUNT(1) <> 1
GROUP BY StartDate,
ClientID;

![SQL Query aggregate may not appear in WHERE clause
[编程语言教程]](https://www.zixueka.com/wp-content/uploads/2024/01/1706709250-b8e273f5a7512f7.jpg)
