SQL Interview Question - Find Nth Highest Salary | LeetCode

  Рет қаралды 40,006

Sumit Mittal

Sumit Mittal

Күн бұрын

Пікірлер: 29
@sumitmittal07
@sumitmittal07 2 жыл бұрын
Checkout the Big Data course details here: trendytech.in/?referrer=youtube_lc2
@ashishranjan4387
@ashishranjan4387 8 ай бұрын
For a non IT data analyst aspirant like me, this was a wonderful session. Each and every thing explained concept is clear
@arunsundar3739
@arunsundar3739 8 ай бұрын
learnt new concepts : isNull & offset, also how to approach a problem in multiple ways, thank you very much sir :)
@sayantansarbadhikary6917
@sayantansarbadhikary6917 6 ай бұрын
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
@MAYANKKUMAR-kg5kc
@MAYANKKUMAR-kg5kc 2 жыл бұрын
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.
@rawatbobby8883
@rawatbobby8883 6 ай бұрын
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 😎❤
@pranutabedru4395
@pranutabedru4395 2 жыл бұрын
Thank you Sir for clearing the concept
@ashitosh501
@ashitosh501 2 жыл бұрын
Make video on MySQL performance tuning
@mallikarjunpatil7553
@mallikarjunpatil7553 2 жыл бұрын
Thanks for explaining multiple approaches. it seems IFNULL() not working in oracle
@Anonymous_it_is
@Anonymous_it_is 2 жыл бұрын
you can use 'NVL' for oracle DB, it works exactly same
@pratiksawalkar1531
@pratiksawalkar1531 Жыл бұрын
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
@mallikarjunpatil7553
@mallikarjunpatil7553 2 жыл бұрын
Waiting for next Video
@SahilGupta-gy5ey
@SahilGupta-gy5ey 2 жыл бұрын
Advance Version - Find n ( eg 10 ) highest salary without order by clause..
@arunavabiswas9177
@arunavabiswas9177 2 жыл бұрын
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.
@sumibits
@sumibits 2 жыл бұрын
I am looking for SQL guidance… Do you have SQL live course ?
@sumitmittal07
@sumitmittal07 2 жыл бұрын
Hi, You can checkout my SQL playlist where I cover important topics of SQL.
@messi_codes
@messi_codes 2 жыл бұрын
thanks
@sukanyaiyer2671
@sukanyaiyer2671 2 жыл бұрын
Can you give your solution. ..sql query txt file as well.. Or can post it on your Github and share the link
@arunprasadhsj
@arunprasadhsj 2 жыл бұрын
Thank you :)
@mohammedasif4349
@mohammedasif4349 2 жыл бұрын
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??
@ooyessabhi
@ooyessabhi Жыл бұрын
Before Return Statement declare and set another variable as N-1 and use that in query. See the below query for reference: CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT BEGIN DECLARE M INT; SET M=N-1; RETURN ( # Write your MySQL query statement below. SELECT DISTINCT Salary FROM Employee ORDER BY Salary DESC LIMIT M, 1 ); END
@ashishranjan4387
@ashishranjan4387 9 ай бұрын
Instead of limit 1 offset 1, can not we do limit 1,1
@ayushsen293
@ayushsen293 2 жыл бұрын
Thanks sir.. approaches are really interesting... but i think oracle dont have IFNULL feature .. not sure how to get null with 3rd approach
@Anonymous_it_is
@Anonymous_it_is 2 жыл бұрын
you can use 'NVL' for oracle
@harshrajvaghela699
@harshrajvaghela699 2 жыл бұрын
sir when next video on sql playlist
@AbhishekKumar-eh1ed
@AbhishekKumar-eh1ed 2 жыл бұрын
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.
@nandinisugandhi748
@nandinisugandhi748 Жыл бұрын
you can use partition by clause then
@sakshijain3534
@sakshijain3534 8 ай бұрын
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;
@abimanyur7765
@abimanyur7765 4 ай бұрын
i think you have missed using DISTINCT function, isn't it? without that...rown=2 wont give exact results. pls correct me if wrong.
Very Famous SQL Interview Question | Department Highest Salary
13:39
كم بصير عمركم عام ٢٠٢٥😍 #shorts #hasanandnour
00:27
hasan and nour shorts
Рет қаралды 12 МЛН
А я думаю что за звук такой знакомый? 😂😂😂
00:15
Денис Кукояка
Рет қаралды 6 МЛН
Quando A Diferença De Altura É Muito Grande 😲😂
00:12
Mari Maria
Рет қаралды 22 МЛН
Long Nails 💅🏻 #shorts
00:50
Mr DegrEE
Рет қаралды 20 МЛН
Part 1   How to find nth highest salary in sql
11:45
kudvenkat
Рет қаралды 1,9 МЛН
Leetcode SQL Interview Questions  | Practise SQL questions
17:50
Sumit Mittal
Рет қаралды 22 М.
LeetCode 175 | SQL Interview Questions on LeetCode
20:59
Sumit Mittal
Рет қаралды 56 М.
Rank and Dense Rank in MySQL - Important SQL Interview Question
18:12
Row Number Function in MySQL | Important SQL Interview Question
15:02
Solving LeetCode SQL Interview Questions | Part 1/3
27:13
Alex The Analyst
Рет қаралды 26 М.
كم بصير عمركم عام ٢٠٢٥😍 #shorts #hasanandnour
00:27
hasan and nour shorts
Рет қаралды 12 МЛН