+ 1
Why does this query return to many counts?
SELECT TOP (100) PERCENT DATEADD(dd, DATEDIFF(dd, 0, Date), 0) AS ALLDates, COUNT(Description) AS DeviC, COUNT(Date) AS AllC FROM dbo.AllKi GROUP BY DATEADD(dd, DATEDIFF(dd, 0, Date), 0) HAVING (COUNT(*) > 1)
1 Answer
0
Without knowing anything about the datasets or how many counts you were actually expecting, if I were to hazard a guess, it would be because you are counting everything greater than 1 with the asterisk.