SQL Window keywords
P
PARTITION BY
The SQL PARTITION BY clause divides rows into groups for window functions.
R
RANK
The SQL RANK() function ranks rows within a partition, allowing ties.
ROW_NUMBER
The SQL ROW_NUMBER() function assigns a unique sequential number to rows within a partition.