AlgoMaster Logo
All categories

SQL Animations

Joins, window functions, and how queries actually execute.

Query Execution

1
Query Execution Order

Joins

6
Cross Join
Full Outer Join
Inner Join
Left Join
Right Join
Self Join

Aggregation & Grouping

6
Aggregate Functions
Group By
Having Vs Where
CUBE vs ROLLUP
Grouping Sets
Window Vs Group By

Functions & Expressions

3
CASE Expression
COALESCE / NULLIF
DISTINCT

Subqueries & CTEs

5
Correlated Subquery
IN vs EXISTS
Subquery
Cte
Recursive Cte

Set Operations

2
Intersect Except
Union Vs Union All

Window Functions

8
Running Total
FIRST_VALUE / LAST_VALUE
Frame Clause
Lag Lead
Ntile
Partition By
PERCENT_RANK / CUME_DIST
Row Number Rank