October 11, 2026 1 min read

The Ultimate SQL Cheatsheet

Advanced SQL window functions, CTEs, and performance tuning for analytical data warehouses.

1. Window Functions

Rankings and aggregates over partitions.

SELECT 
    user_id,
    amount,
    SUM(amount) OVER (PARTITION BY user_id ORDER BY transaction_date) as running_total,
    ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY transaction_date DESC) as recent_rank
FROM transactions

1. Window Functions

Activity Feed