Our Training Programs

All contents are copyright of their authors.

What is the difference between a "Where" clause and a "Having" clause

What is the difference between a "Where" clause and a "Having" clause

Rahul Sharma

14yAsked Nov 8, 2012, 6:05 AM1.9k

Hi friends

What is the difference between a "Where" clause and a "Having" clause?

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Jesuraja I14y ago
Hi,

WHERE clause used to filter records from given condition for column(s).

Example:
SELECT        StudentID, StudentName, Mark
FROM           Students
WHERE Mark > 80

HAVING clause is used to filter records only from aggregate function's result.

Example:
SELECT         StudentID, StudentName, AVG(Mark) AS Average
FROM Students
GROUP BY   StudentID, StudentName
HAVING        AVG(Mark) > 80
Satyapriya Nayak14y ago
Specifies a search condition for a group or an aggregate. HAVING can be used only with the SELECT statement. HAVING is typically used in a GROUP BY clause. When GROUP BY is not used, HAVING behaves like a WHERE clause. Having Clause is basically used only with the GROUP BY function in a query. WHERE Clause is applied to each row before they are part of the GROUP BY function in a query.
Vithal Wadje14y ago
where clause is used to retrive specific records

and having clause is used with aggrigate function