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
kang
Messages: 89
Registered: November 2007
Member
How to create where conditions for analytic functions?
like "having" in aggregate functions.
I always add additional select * to put the where clauses.
like
select *
from (select count(member) over(partition by detp) as cnt)
where cnt > 3
any ideas?

TIA
Re: conditions for analytic function [message #311820 is a reply to message #311791] Mon, 07 April 2008 00:30 Go to previous message
Frank
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: Fri Dec 02 14:09:52 CST 2016

Total time taken to generate the page: 0.13112 seconds