#SQL Interview Question -Second highest salary using dense rank analytical function || 3rd highest

Hi All,
My name is Ankit Shrivastava and I am Data Engineer.
Today this #vlog is regarding mostly asked #sql #sqlinterviewquestions .

This #vlog is regarding is SQL Interview Questions - How to find Second highest/third highest (n th highest/lowest) salary using dense rank analytical function.
I have also covered difference between rank and dense rank analytical function.

Please find the DDL statement below;-

insert into emp values (100,'Ankit','IT',1000);
insert into emp values (101,'Amit','IT',1000);
insert into emp values (102,'Saurabh','HR',2000);
insert into emp values (103,'Varun','HR',4000);
insert into emp values (104,'Rahul','SALES',4000);
insert into emp values (105,'Ankit','Operations',5000);

#analyticfunction #rank #denserank
#sqlinterviewquestions #sqlinterviewquestionsandanswers #value
#sql #innerjoin #leftjoin #rightjoin #fullouterjoin
#amazon #meta #walmart #google #databaseexercises #dataengineeringessentials #salary #oracle #sqlcourse #sqlinterview
#trendinginterview #cartesianproducts #interview #oracle #interviewtips #mysql #interviewready #interviewpreparation #sqljoins #lifeofdataengineer
#highest #second #interviewready #interviewhacks #complex #complexscenario #scenarios #queries #plsql #sqlserver #postgresql #postgres