can you pls let me know if we can use HAVING clause with analytic function
select eid,empno,sum(sal) over(partition by year)
from employee
where dept = 'SALES'
having sum(sal) > 10000
I m getting error while using the above,
IS that we can use HAVING clause with partition by
Thanks in advance