Ranking Functions in SQL (Rank vs Dense_Rank vs Row_Number) | Comparison with example

preview_player
Показать описание
This video explains the difference between 3 SQL functions - Rank(), Dense_Rank() and Row_Number().

Example shown in the video is for PostgreSQL, but explanation will hold true for all variants of SQL.

Timestamp:
00:00 - Introduction
00:55 - Rank() Function
02:17 - Dense_Rank() Function
03:08 - Row_Number() Function
Рекомендации по теме