Re: SQL Question

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 12 Sep 2006 22:05:08 -0700
Message-ID: <1158123902.481397@bubbleator.drizzle.com>

Anil G wrote:
> Guys:
>
> I am trying to work with Analytic functions available in Oracle,
>
> SELECT org,home,MAX(t_qty) OVER (PARTITION BY org,home)
> FROM TBL01
> WHERE home IS NOT NULL
>
> Still struggling..
>
> Thanks,

While that may be the case what does an analytic function have to do with your proposed result set?

ORG HOME T_QTY E_QTY
---- ---- ----- -----
O14 O1 15 109
O23 O2 27 200

My answer would be absolutely nothing.

Care to be a bit more explicit about what you are REALLY doing?

It is the price for getting any help other than this: http://tahiti.oracle.com.

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group

Received on Wed Sep 13 2006 - 00:05:08 CDT