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...
Want to create exercises like this yourself? Click here.
No hints are availble for this assesment
Answer is not availble for this assesment
Loading comments...