Registrations Closing Soon for DevOps Certification Training by CloudxLab | Registrations Closing in

  Enroll Now

HAVING clause

It works as WHERE clause for aggregate functions.

Example - You need to know city wise max salaries of employees where the max salary is more than 2150.

select max(e.empsal) max_sal, d.depcity
from emp e, deptt d
where e.depid = d.depid
group by d.depcity
having max(e.empsal) > 2150 -- to show max sal > 2150
order by d.depcity
;

No hints are availble for this assesment

Answer is not availble for this assesment

Loading comments...