Only Few Seats Left for Advanced Certification Courses on Data Science, ML & AI by E&ICT Academy IIT Roorkee

  Apply 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...