Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Ranking functions
Selecting n-th row
Summary
22. Summary

## Instruction

That was another correct answer! Okay, let's review what we've learned in this part:

• The most basic usage of ranking functions is: RANK() OVER(ORDER BY column1, column2...).
• The ranking functions we have learned:
• RANK() – returns the rank (a number) of each row with respect to the sorting specified within parentheses.
• DENSE_RANK() – returns a 'dense' rank, i.e. there are no gaps in numbering.
• ROW_NUMBER() – returns a unique rank number, so even rows with the same value get consecutive numbers.
• NTILE(x) – distributes the rows into a specific number of groups, provided as x.
• To get col1 of the row with rank place1 in a ranking sorted by col2, write:
WITH ranking AS
(SELECT
RANK() OVER (ORDER BY col2) AS RANK,
col1
FROM table_name)

SELECT col1
FROM ranking
WHERE RANK = place1;


Alright, it's time for a short quiz!

## Exercise

Press to continue.