SQL Tips and Tricks - A Simple and Tricky SQL Question | Rank Only Duplicates | SQL Interview Questions

This video we will discuss a SQL question where we need to rank only the duplicate records and unique records should have null values. Consider subscribing to the channel: https://www.youtube.com/channel/UCk7NcgnqCmui1AV7MTXZwOw/ Playlist of SQL interview scenario based question and solutions: https://youtube.com/playlist?list=PLBTZqjSKn0IeKBQDjLmzisazhqQy4iGkb script: create table list (id varchar(5)); insert into list values ('a'); insert into list values ('a'); insert into list values ('b'); insert into list values ('c'); insert into list values ('c'); insert into list values ('c'); insert into list values ('d'); insert into list values ('d'); insert into list values ('e'); #sql #interview #windowfunctions