Window function

Report a typo

Match the corresponding sections of the window function to its meaning.

Match the items from left and right columns
ROW_NUMBER()
RANK()
DENSE_RANK()
NTILE()
If there are two rows with the same value, both will receive the same rank, and the next rank assigned will be 2.
If there are two rows with the same value, both will receive a rank of 1, and the next rank assigned will be 3.
Divides the rows in the subset into a specified number of groups, assigning each row a group number.
Assigns a unique sequential integer to each row in the subset, starting at 1.

Create a free account to access the full topic