Re: Frequency Count

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 04 Aug 2006 09:12:27 -0700
Message-ID: <1154707948.383027@bubbleator.drizzle.com>

Bertie Brink wrote:
> DA Morgan wrote:

>>
>> http://tahiti.oracle.com
>>
>> Search for: ANALYTIC FUNCTIONS
>>
>> You need to do your own schoolwork.

>
> Not really schoolwork but thanks for the tip anyway.
>
> --
> Bertie Brink
> Life is a sexually transmitted disease. R. D. Laing
> http://www.setdefault.com/ : http://www.csmonitor.com/

As Charles points out:

"table name is MY_TABLE and the column names are PROD1, PROD2, PROD3"

That's school work by any reasonable definition. ;-)

You will find a page summarizing all of the analytic functions in Morgan's Library at www.psoug.org. There are working demos of some of them there as well.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Fri Aug 04 2006 - 11:12:27 CDT