SQL Recipe: Compare with Neighbors

Calculate the difference between each record and the previous or next one.


According to the standard, we should use be using FETCH.

SQL Recipe: Segmenting Data

Assigning each record to a specific segment based on the value of one or more columns.

SQL Cheat Sheet

For those who knew SQL, but kinda forgot it.

SQL Recipe: Ranking Records

Assigning a rank to each row based on the value of one or more columns.

Rolling Aggregates with SQL Window Functions

Moving averages, cumulative totals and other sliding aggregates.

Aggregating Data with SQL Window Functions

Comparing individual values with totals and averages.

Interactive SQL Examples in JavaScript

Turn static SQL code in your articles into executable examples.

Comparing by Offset with SQL Window Functions

Comparing records with neighbors and boundaries.

Ranking Data with SQL Window Functions

Making ratings and dividing data into partitions.

Why Use SQL Window Functions

To build great analytical reports without Excel.

SQL Window Functions Explained [Book]

A clear and visual introduction to window functions in SQL.

The Ultimate SQLite Extension Set

Regexes, math, file IO and over 100 other functions.

What's new in SQLite 3.37

Strict tables, any type and a new pragma.

Data Visualization Guide

CC-licensed design guide for presentations, reports, and dashboards.