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



Published
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
Category
Job
Be the first to comment