Artificial Intelligence (AI) & Machine Learning Course for ManagersEnroll 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 ;
Taking you to the next exercise in seconds...