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

Question

Hi friends What is the difference between a 'Where' clause and a 'Having' clause?

Jesuraja I · Answer

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 Nayak · Answer

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 Wadje · Answer

where clause is used to retrive specific records and having clause is used with aggrigate function

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

Answers (3)