HAVING and WHERE clause

From: <suisum_at_ecn.ab.ca>
Date: 5 Jan 99 20:56:37 GMT
Message-ID: <36927c85.0@ecn.ab.ca>

I read this question from somewhere. I am confused as I think the correct answer should be 2. But the correct answer is 1.

Which clause would you use to exclude rows from a group calculation?

1. WHERE
2. HAVING
3. ORDER BY
4. INTO

Will HAVING is for a group of rows and WHERE is for one row?

--
Best regards, Received on Tue Jan 05 1999 - 14:56:37 CST