Databases · Middle · Question 26 of 75

What is the difference between `RANK()` and `DENSE_RANK()`?

✓Correct answer: With ties, RANK() skips numbers (1, 1, 3); DENSE_RANK() doesn't (1, 1, 2)
2RANK() works only with numbers
3DENSE_RANK() is faster

Explanation

ROW_NUMBER() gives every row a unique number even for ties, in an order you should make deterministic with extra sort columns.

Further reading

PostgreSQL: Window functions ↗

Test yourself

Take the Databases · Middle quiz: questions and options are shuffled, and you get a review of your mistakes at the end.