Master PostgreSQL RANK vs. DENSE_RANK, gaps vs no gaps using Simple Examples!

SQL window ranking functions PostgreSQL RANK PostgreSQL DENSE_RANK postgresql rank vs dense_rank postgresql rank dense_rank RANK vs DENSE_RANK in PostgreSQL window functions PostgreSQL ranking functions RANK DENSE_RANK example RANK DENSE_RANK SQL tie handling gaps vs no gap SQL top-N with ties using RANK DENSE_RANK How to use PostgreSQL PARTITION BY How to use OVER clause PostgreSQL data ranking Contents: 00:00 Intro 00:02 Github - source code location 00:22 Example one - create etable employee_sales 00:44 Rank() vs DENSE_RANK - see gaps 01:56 see Rank() used in SQL 02:53 see Dense_Rank() used in SQL 04:15 use RANK and PARTITION BY 05:13 use DENSE_RANK and PARTITION BY 05:56 use WINDOW clause Each example straight forward and easy to understand. #softwarenuggets @softwareNuggets