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:    / @ankitbansal6   Playlist of SQL interview scenario based question and solutions:    • Complex SQL Questions for Interview Prepar...   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