There is the book "Advanced Oracle SQL functions in Oracle 10g", written by Richard Walsh Earp and Sikha Saha Bagui. It is from Wordware, ISBN-13: 978-1-59822-021-6. Chapters 3,4,5 describe the analytic functions from Oracle with exaxmples. Chapter 6 goes about the MODEL clause. Herald ten Dam www.superconsult.nl ________________________________ Van: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] namens Taylor, Chris David [ChrisDavid.Taylor@xxxxxxxxxxxxxxx] Verzonden: dinsdag 29 september 2009 22:09 Aan: 'oracle-l@xxxxxxxxxxxxx' Onderwerp: Analytic SQL Book? Does anyone have any recommendations for a good/detailed Oracle analytic SQL book (analytic functions from the "ground up")? Thanks, Chris Taylor Sr. Oracle DBA Ingram Barge Company Nashville, TN 37205 Office: 615-517-3355 Cell: 615-354-4799 Email: chris.taylor@xxxxxxxxxxxxxxx<mailto:chris.taylor@xxxxxxxxxxxxxxx> 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.