Home » SQL & PL/SQL » SQL & PL/SQL » conditions for analytic function (10g)
conditions for analytic function [message #311791] Sun, 06 April 2008 20:45 Go to next message
Messages: 89
Registered: November 2007
How to create where conditions for analytic functions?
like "having" in aggregate functions.
I always add additional select * to put the where clauses.
select *
from (select count(member) over(partition by detp) as cnt)
where cnt > 3
any ideas?

Re: conditions for analytic function [message #311820 is a reply to message #311791] Mon, 07 April 2008 00:30 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
That is the correct way.
Previous Topic: group by/rollup?
Next Topic: Cursor Question
Goto Forum:

Current Time: Thu Aug 24 03:55:46 CDT 2017

Total time taken to generate the page: 0.01995 seconds