Advanced Analytical Functions Guide in Oracle / SQLServer

Question

Can anyone recommend a good tutorial (or a book, perhaps) that covers advanced topics when using analytic functions?

I am looking for something that covers both Oracle and SQLServer, or two separate manuals if one of them does not exist. It would be useful to offer good examples of using non-trivial functions (LAG, LEAD, GROUPING, PERCENTILE).

Please do not point me to the basic reference material of Oracle Technet or MSDN - I saw this. I am looking for something that goes beyond just syntactic or trivial examples.

Answer 1

I like the tutorial / introduction for implementing PostgreSQL. It not only covers simple syntax, but also introduces the concepts behind them. This perfectly explains what a window is and the frame inside the window.

PostgreSQL syntax is pretty much compatible with Oracle syntax, so it will help you. Not sure how it is implemented in SQL Server.

Anyway here is the link: http://www.pgcon.org/2009/schedule/events/128.en.html

Direct link to PDF: http://www.pgcon.org/2009/schedule/attachments/98_Windowing%20Functions.pdf

Answer 2

Oracle Tom Kyte Expert Oracle (Signature Edition). Expert Oracle . , -, .

Google " Tom Kyte"

SQL Server, ( ).

Apress "Oracle SQL Recipes" - , - Google ( " " ) , - .