I like the tutorial/introduction for the PostgreSQL implementation. It does not only cover the mere syntax but also introduces the concepts behind them. It explains quite nicely what a a window is and what a frame inside a window is.
The PostgreSQL syntax is pretty much compatible with the Oracle syntax, so that should help you there. Not sure how much of that is implemented in SQL Server.
For Oracle, there's a good chapter in Tom Kyte's Expert Oracle (Signature Edition). The earlier edition of Expert Oracle lacks this chapter. This goes into a lot more detail than most online articles I've seen.
Preview on Google Books by searching on "Tom Kyte Analytic Functions"
Much of this should be appropriate to SQL Server, although specific syntax may vary (as usual).
Apress also have a book called 'Oracle SQL Recipes' - I don't own this, but again the preview on Google Books ('analytic function recipes') looks like it may be very useful - although it comes from an example rather than concept based approach.
发布评论
评论（2）
我喜欢 PostgreSQL 实现的教程/介绍。它不仅涵盖了单纯的语法，还介绍了它们背后的概念。它很好地解释了什么是窗口以及窗口内的框架是什么。
PostgreSQL 语法与 Oracle 语法非常兼容，因此这应该对您有所帮助。不确定其中有多少是在 SQL Server 中实现的。
无论如何，这是链接：
http://www.pgcon.org/2009/schedule/events/ 128.en.html
PDF 直接链接：
http://www.pgcon.org/2009/schedule/attachments/ 98_Windowing%20Functions.pdf
I like the tutorial/introduction for the PostgreSQL implementation. It does not only cover the mere syntax but also introduces the concepts behind them. It explains quite nicely what a a window is and what a frame inside a window is.
The PostgreSQL syntax is pretty much compatible with the Oracle syntax, so that should help you there. Not sure how much of that is implemented in SQL Server.
Anyway here is the link:
http://www.pgcon.org/2009/schedule/events/128.en.html
Direct Link to the PDF:
http://www.pgcon.org/2009/schedule/attachments/98_Windowing%20Functions.pdf
对于 Oracle，Tom Kyte 的 Expert Oracle（签名版）中有一个很好的章节。 Expert Oracle 的早期版本缺少本章。这比我见过的大多数在线文章都要详细得多。
通过搜索“Tom Kyte 分析函数”在 Google 图书上进行预览，
其中大部分内容应该适合 SQL Server，尽管具体语法可能会有所不同（像往常一样）。
Apress 还有一本名为“Oracle SQL Recipes”的书 - 我没有这本书，但 Google Books 上的预览（“分析函数菜谱”）看起来可能非常有用 - 尽管它来自示例而不是概念基于的方法。
For Oracle, there's a good chapter in Tom Kyte's Expert Oracle (Signature Edition). The earlier edition of Expert Oracle lacks this chapter. This goes into a lot more detail than most online articles I've seen.
Preview on Google Books by searching on "Tom Kyte Analytic Functions"
Much of this should be appropriate to SQL Server, although specific syntax may vary (as usual).
Apress also have a book called 'Oracle SQL Recipes' - I don't own this, but again the preview on Google Books ('analytic function recipes') looks like it may be very useful - although it comes from an example rather than concept based approach.