Match the corresponding sections of the window function to its meaning.
Leveraging built-in SQL functions and features
Window function
Report a typo
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
By continuing, you agree to the JetBrains Academy Terms of Service as well as Hyperskill Terms of Service and Privacy Policy.