New posts in Window Functions

A more intelligent ntile

SQL counting distinct over partition

How to get the last not-null value in an ordered column of a huge table?

Explain an OVER clause

Adding a ROW_NUMBER() with no column to ORDER BY?

Can I calculate ROW_NUMBER() for only consecutive records?

How to select the set of last non-NULL values per column over a group?

Sum of previous n number of columns based on some category

Optimize Subquery with Windowing Function

Grouping or Window