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;