Question

Consider the following Query in SQL. SELECT Department, avg(salary)

From Employee 

Where branch = ‘Kannur’ 

Group By Department 

Having avg (salary) > 7000, 

Compare the ‘where’ clause and ‘Having’ 

Clause using the above query.

Answer 1

‘where’ clause applies on single rows but Having clause applies on a group.