Re: Analytic SQL Book?
Date: Tue, 29 Sep 2009 16:27:49 -0400
The best in terms of documentation is the Data Warehouse Guide: http://download.oracle.com/docs/cd/B28359_01/server.111/b28313/analysis.htm#i1007779
Other than that, a little practice on small sets of data will do you quite a bit of good. Also, if you think of analytics as a GROUP BY within a subset of your result set, it helps out a bit. The PARTITION BY is effecctively a GROUP BY clause.
Playing around with it, especially ROW_NUMBER and RANK with small sets will do far more than any book can give you...in my opinion anyway.
On Tue, Sep 29, 2009 at 4:09 PM, Taylor, Chris David < ChrisDavid.Taylor_at_ingrambarge.com> wrote:
> Does anyone have any recommendations for a good/detailed Oracle analytic
> SQL book (analytic functions from the "ground up")?
> *Chris Taylor*
> *Sr. Oracle DBA*
> Ingram Barge Company
> Nashville, TN 37205
> Office: 615-517-3355
> Cell: 615-354-4799
> Email: chris.taylor_at_ingrambarge.com
> *CONFIDENTIALITY NOTICE**: This e-mail and any attachments are
> confidential and may also be privileged. If you are not the named recipient,
> please notify the sender immediately and delete the contents of this message
> without disclosing the contents to anyone, using them for any purpose, or
> storing or copying the information on any medium.*