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 P...

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

• #science_technology
• #sql
• #sql_interview_questions
• #amazon_interview_questions
• #sql_interview_questions_and_answers
• #rank_duplicates_sql