I'll check them out. Much appreciated! (-; On Tue, Aug 12, 2014 at 10:46 AM, Chris Taylor < christopherdtaylor1994@xxxxxxxxx> wrote: > I had to use a combination of resources together. I the Oracle Data > Warehousing documentation (believe it or not) helped me a ton - reading the > documentation (in order of each function) and then looking at examples from > different blogs to see the query in action (and various forms it could > take). > > Then I took some of the most useful functions and started writing them > against database tables where I wanted some details - so I could get used > to using them: > > Links: > http://docs.oracle.com/cd/E11882_01/server.112/e25554/analysis.htm#DWHSG021 > > Helpful usage examples: > > http://www.oracle-base.com/articles/misc/rank-dense-rank-first-last-analytic-functions.php > http://www.orafaq.com/node/55 > > http://www.oracle.com/technetwork/issue-archive/2013/13-mar/o23sql-1906475.html > > Book that was really helpful (but was (IMHO) a rehash of the Oracle > documentation on the matter in better form): > http://www.rampant-books.com/book_0802_advanced_sql_programming.htm by > Laurent Schneider > > Also Laurent Schneider has several posts scattered around the web with > some good examples. > > Best of luck! > > Chris > > P.S. When you finally write a MODEL statement and understand it and can > manipulate it, it's AWESOME. (I've only done it a handful of times and > would have to refresh my own use of it because I never see it in use by > anyone besides me) > > > > On Tue, Aug 12, 2014 at 10:09 AM, Adric Norris <landstander668@xxxxxxxxx> > wrote: > >> Can anyone recommend a good reference (preferably with lots of examples) >> on the use of Oracle analytic functions? It tends to be something of a >> struggle whenever I use the beasties, and I'd like to get my head wrapped >> around them a bit better. >> >> Thanx! >> >> -- >> "In the beginning the Universe was created. This made a lot of people >> very angry and has been widely regarded as a bad move." -Douglas Adams >> > > -- "I'm too sexy for my code." -Awk Sed Fred