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