主页 / user-73810

Kaptah's questions

Martin Hope
Kaptah
Asked: 2025-02-15 01:25:16 +0800 CST
  • 4

我有这个疑问

SELECT
    a.Campaign,
    COUNT(DISTINCT a.Customer) AS 'Records',
    MIN(a.LastRecord) AS 'First Record',
    MAX(a.LastRecord) AS 'Last Record',
    MAX(a.daytime) AS 'Records up to'
FROM 
    contacts.dbo.contacts_ALL a 
JOIN 
    sms b ON a.Customer = b.Customer
WHERE 
    a.LastRecord >= MIN(b.smsDelivered)
GROUP BY 
    a.Campaign
HAVING 
    a.LastRecord >= MIN(b.smsDelivered)
ORDER BY 
    a.Campaign DESC, [First Record]

我从 SQL Server 收到此错误：

除非聚合位于 HAVING 子句或选择列表中的子查询中，并且被聚合的列是外部引用，否则聚合可能不会出现在 WHERE 子句中。

那里可能有什么问题？

sql