SQL with Jupyter Notebook Tutorial

31 / 61

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.

%%sql
select max(e.empsal) max_sal, d.depcity
from emp_<<your lab username>> e, deptt_<<your lab username>> d
where e.depid = d.depid
group by d.depcity
having max(e.empsal) > 2150 
order by d.depcity
;

No hints are availble for this assesment

Answer is not availble for this assesment

Loading comments...