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: TRIGGER For Updating row if exists and insert new row if it not exists
Next Topic: Problem with PIPES
Goto Forum:

Current Time: Wed Oct 26 22:16:14 CDT 2016

Total time taken to generate the page: 0.08523 seconds