Consider the following Query in SQL. SELECT Department, avg(salary)
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.
5 views