Having vs Where Clause

Asked by: Interviewer 3193 views SQL

What are the differences between having and where clause. Where is each one used?

PANDU CRAZY on Feb 18, 2012 Reply

SELECT BUSINESS_UNIT,COUNT(*) FROM PS_PO_HDR GROUP BY BUSINESS_UNIT HAVING COUNT(*) < 10; This is HAVING criteria. HAVING is used to perform an action on groups created by GROUP BY similar to that of the WHERE clause on rows in a basic SQL statement. The WHERE clause limits the rows evaluated. The HAVING clause limits the grouped rows returned.

+4 Votes 0 Votes 0 Votes
candidate on May 12, 2012 Reply

Pandu has the right answer!

+1 Votes 0 Votes 0 Votes