Only Few Seats Left for Advanced Certification Courses on Data Science, ML & AI by E&ICT Academy IIT RoorkeeApply Now
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