SELECT AccountNo,CustomerName,count(distinct CollectDate)
FROM dbo.tb_inf
WHERE ConsumeTime between '"&date_begin&"' and '"&date_end&"' group by AccountNo,CustomerName
ORDER BY AccountNo ASC
什么原因?
[Microsoft][ODBC SQL Server Driver][SQL Server]列 'dbo.tb_inf.AccountNo' 在选择列表中无效,因为该列未包含在聚合函数中,并且没有 GROUP BY 子句。
[Microsoft][ODBC SQL Server Driver][SQL Server]列 'dbo.tb_inf.CustomerName' 在选择列表中无效,因为该列未包含在聚合函数中,并且没有 GROUP BY 子句。