SQL Cheatsheet

PARTITION BY: This clause divides the rows into groups, similar to how GROUP BY works, but without collapsing the rows. Each group is processed independently. Think of it as creating mini-tables within your result set.
ORDER BY: This defines the logical order of rows within each partition. This is crucial for functions that depend on sequence, like ranking or \`LAG\`/\`LEAD\`.
ROWS BETWEEN: This specifies the "frame" or subset of rows within the current partition and order that the window function will consider for its calculation. For example, UNBOUNDED PRECEDING AND CURRENT ROW means from the start of the partition up to the current row.

by Shobhit Dev

Window Functions CTEs Subqueries CASE Statement Set Operators Indexes Stored Procedures Transactions Performance Tuning

SQLCheatsheet

SQL is the backbone of data. This cheatsheet helps you master advanced SQL concepts — in a visual, fun & coder-friendly way, including interview prep.

Quick Links

SQL Game Changer Cheatsheet