Difference between Having & Where Clause

[Roopanwita]

Hi,
I am asking a very basic question.
Can anyone explain me the difference between Having & Where Clause.
Thanks in advance,
Roopanwita

[amitpatel66]

WHERE CLAUSE - for general conditions if any to be included in the query
Eg: WHERE date BETWEEN '01-JAN-07' AND SYSDATE

HAVING CLAUSE - used to restrict the data when using any aggregrate function in your query.

Eg: SELECT empno, SUM(marks) FROM emp GROUP BY empno HAVING SUM(marks) > 600;

[jporter892]

Clearest answer to this question

I found a great answer to this question here:

http://www.programmerinterview.com/sql/clauses.php

[OraMaster]

Hi,
I am asking a very basic question.
Can anyone explain me the difference between Having & Where Clause.
Thanks in advance,
Roopanwita

keep in mind "always use where before having in sql"