#Window Functions

4 snippets

• SQL

  Top N rows per group

  Get the latest or highest N rows for each category using ROW_NUMBER in a subquery.

• SQL

  RANK, DENSE_RANK and ROW_NUMBER

  Understand how the three ranking window functions treat ties, with one query that shows all three.

• SQL

  Percent of total with a window function

  Show each row's share of the grand total or of its group without a self-join.

• SQL

  Moving average with a window frame

  Compute a 7-day rolling average with AVG over a ROWS BETWEEN frame.