SQL Interview Question - Find Nth Highest Salary | LeetCode

𝐖𝐚𝐧𝐭 𝐭𝐨 𝐌𝐚𝐬𝐭𝐞𝐫 𝐒𝐐𝐋? 𝐋𝐞𝐚𝐫𝐧 𝐒𝐐𝐋 𝐭𝐡𝐞 𝐫𝐢𝐠𝐡𝐭 𝐰𝐚𝐲 𝐭𝐡𝐫𝐨𝐮𝐠𝐡 𝐭𝐡𝐞 𝐦𝐨𝐬𝐭 𝐬𝐨𝐮𝐠𝐡𝐭 𝐚𝐟𝐭𝐞𝐫 𝐜𝐨𝐮𝐫𝐬𝐞 - 𝐒𝐐𝐋 𝐂𝐡𝐚𝐦𝐩𝐢𝐨𝐧𝐬 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐛𝐲 𝐒𝐮𝐦𝐢𝐭 𝐒𝐢𝐫!

"𝐀 8 𝐰𝐞𝐞𝐤 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐝𝐞𝐬𝐢𝐠𝐧𝐞𝐝 𝐭𝐨 𝐡𝐞𝐥𝐩 𝐲𝐨𝐮 𝐜𝐫𝐚𝐜𝐤 𝐭𝐡𝐞 𝐢𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰𝐬 𝐨𝐟 𝐭𝐨𝐩 𝐩𝐫𝐨𝐝𝐮𝐜𝐭 𝐛𝐚𝐬𝐞𝐝 𝐜𝐨𝐦𝐩𝐚𝐧𝐢𝐞𝐬 𝐛𝐲 𝐝𝐞𝐯𝐞𝐥𝐨𝐩𝐢𝐧𝐠 𝐚 𝐭𝐡𝐨𝐮𝐠𝐡𝐭 𝐩𝐫𝐨𝐜𝐞𝐬𝐬 𝐚𝐧𝐝 𝐚𝐧 𝐚𝐩𝐩𝐫𝐨𝐚𝐜𝐡 𝐭𝐨 𝐬𝐨𝐥𝐯𝐞 𝐚𝐧 𝐮𝐧𝐬𝐞𝐞𝐧 𝐏𝐫𝐨𝐛𝐥𝐞𝐦."

𝐇𝐞𝐫𝐞 𝐢𝐬 𝐡𝐨𝐰 𝐲𝐨𝐮 𝐜𝐚𝐧 𝐫𝐞𝐠𝐢𝐬𝐭𝐞𝐫 𝐟𝐨𝐫 𝐭𝐡𝐞 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 -

𝐖𝐚𝐧𝐭 𝐭𝐨 𝐥𝐞𝐚𝐫𝐧 𝐁𝐢𝐠 𝐃𝐚𝐭𝐚 𝐛𝐲 𝐒𝐮𝐦𝐢𝐭 𝐒𝐢𝐫?
𝐜𝐡𝐞𝐜𝐤𝐨𝐮𝐭 𝐭𝐡𝐞 𝐛𝐢𝐠 𝐝𝐚𝐭𝐚 𝐜𝐨𝐮𝐫𝐬𝐞 𝐝𝐞𝐭𝐚𝐢𝐥𝐬

I have trained over 20,000+ professionals in the field of Data Engineering in the last 5 years.

SQL Interview Question - Find Nth Highest Salary | LeetCode

Do Like, Comment & Subscribe ..

𝗝𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:🔥

In this video, we will solve SQL question on LeetCode. LeetCode is an excellent platform for practicing SQL Queries. The SQL Questions on LeetCode are framed pretty similar to how they are asked on SQL Interviews hence solving SQL questions on LeetCode can give you a good hands on experience on solving real world SQL questions.

Find the nth highest Salary is a very frequently asked SQL Interview question.

#SQL #RDBMS #database #bigdata #dataengineering

[arunsundar]

learnt new concepts : isNull & offset, also how to approach a problem in multiple ways, thank you very much sir :)

[sayantansarbadhikary]

Very well explained sir..
The way you explain things ans then give the solution actually prepares our way to think logically about the problems
Thanks a lot.
Please come up with more learnings

[ashishranjan]

For a non IT data analyst aspirant like me, this was a wonderful session. Each and every thing explained concept is clear

[rawatbobby]

Thank you thank you so much, i understand from you rvideo from one go, really amazing sir you are, thanks a lot, and keep moving in this era 😎❤

[MAYANKKUMAR-kgkc]

Hello sir, Can you please share tips to solve this problem statement ?

There's a grocery store sales transaction table with columns Tnx ID, customer ID, product ID, Date of Tnx, quantity, price. Every sales transaction that happens at the store, gets stored in this table. The store also has a customers table with columns Customer ID, Customer Name, Age, Gender, and Locality.
Write an SQL query to find the name and locality of the customer who purchased the highest number of items in the month of Oct’21.

[mallikarjunpatil]

Thanks for explaining multiple approaches.
it seems IFNULL() not working in oracle

[pratiksawalkar]

My Solution:

select case when max(rn) = 1 then null else salary end as SecondHighestSalary
from (select salary, rank() over( order by salary desc) as rn from Employe)a
where rn = 2

[ashitosh]

Make video on
MySQL performance tuning

[pranutabedru]

Thank you Sir for clearing the concept

[arunavabiswas]

Thanks for your videos.They are quite good. I just feel I the offset solution will not work. As you don't know beforehand the number of distinct values that will return and dependending on that you have to provide the offset count.

[ayushsen]

Thanks sir.. approaches are really interesting... but i think oracle dont have IFNULL feature .. not sure how to get null with 3rd approach

[sumibits]

I am looking for SQL guidance… Do you have SQL live course ?

[sukanyaiyer]

Can you give your solution. ..sql query txt file as well.. Or can post it on your Github and share the link

[ashishranjan]

Instead of limit 1 offset 1, can not we do limit 1, 1

[SahilGupta-gyey]

Advance Version - Find n ( eg 10 ) highest salary without order by clause..

[mohammedasif]

In LC Ques no-177 where we've to write solution for Nth highest salary, if we use limit and offset concept then we've to use offset (N-1) but it shows syntax error when we use minus operator. What to do in this case??

[sakshijain]

WITH cte AS (
SELECT
salary,
DENSE_RANK() OVER (ORDER BY salary DESC) AS rown
FROM
employee
)
SELECT
CASE
WHEN rown = 2 THEN salary
ELSE NULL
END AS SecondHighestSalary
FROM
cte;

[AbhishekKumar-ehed]

The solutions are good sir but if there is a question where we have to find second highest salary from each departments then these solutions would not work I guess.