#10
SQL
Window Functions: Compute Without Collapsing
Aggregate functions are powerful, but they come with a cost: when you ask for a summary, you lose the detail. Window functions remove that trade-off. ...
#11 SQLRanking Rows in SQL: ROW_NUMBER, RANK, DENSE_RANK, and NTILE
A window function computes a value across a set of related rows without collapsing them — each row keeps its place in the output, but gains a calculat...
