New posts in Window Functions

Using window function to carry forward first non-null value in a partition

Calculate 40 day moving average w.r.t to a field

Average of last 4 runs of a product

Calculate rolling sum over 7 consecutive day period on PostgreSQL

Date range rolling sum using window functions

Check if contiguous date interval exists

Using DISTINCT in window function with OVER

Store millions of rows of denomalized data or some SQL magic?

What is the difference between COUNT(*) and COUNT(*) OVER()

Find "n" consecutive free numbers from table