How can I do WHERE in COUNT (name) created by a GROUP BY clause?

Question

WHERE is processed before GROUP BY in a SELECT statement. How can I use WHERE on the result of COUNT (name)?

I want it:

SELECT topic, COUNT(name) AS counter
FROM blah
GROUP BY name
WHERE counter <> 1

Answer 1

SELECT topic, COUNT(name) AS counter
FROM blah
GROUP BY topic
HAVING COUNT(name) <> 1

Answer 2

I think you are looking for an item of availability:

http://msdn.microsoft.com/en-us/library/ms180199.aspx

SELECT topic, COUNT(name) AS counter
FROM blah
GROUP BY topic
HAVING COUNT(name) <> 1

Answer 3

, .

WHERE

GROUP BY

HAVING

, COUNT (*) SELECT , , .