20+ SQL Server Interview Questions : kzfaq.info/get/bejne/iauUdKlp0rmvg2g.html Software Architecture Interview Questions : kzfaq.info/get/bejne/d9qEmsaTsbXVfYE.html SQL Step by Step - kzfaq.info/get/bejne/q62cmbNq1J3PnY0.html SQL Server Joins : kzfaq.info/get/bejne/gbqmjKt209ranmw.html 20 MSBI Interview Questions : kzfaq.info/get/bejne/hN2Ppqt2sNSzhXk.html 10+ Power BI Interview Questions : kzfaq.info/get/bejne/edWqlpyIs6i2pGg.html Angular Step by Step Tutorial for Beginners : kzfaq.info/get/bejne/Y5-Glrposqioo2w.html 25 Angular Interview Questions : kzfaq.info/get/bejne/Y9CVotx1r6rXg4E.html 35 Important JavaScript Interview Questions : kzfaq.info/get/bejne/kMhkl7OanKmlfok.html 30 Important C# Interview Questions : kzfaq.info/get/bejne/eLGpoahztdfNeYE.html 25+ OOPS Interview Questions : kzfaq.info/get/bejne/q59pqqSgp9CopoU.html 25 Important ASP.NET Interview Questions : kzfaq.info/get/bejne/pr6dgMeer7unYJs.html 20 MySQL Interview Questions : kzfaq.info/get/bejne/b86WnaZep9a9YmQ.html 20 PHP Interview Questions : kzfaq.info/get/bejne/Z8iggbaq07vWnGw.html 5 MSBI Interview Questions : kzfaq.info/get/bejne/a6toZJiSvafbiYU.html

Select * from employee E1 where n-1 = (select count(*) from employee E2 where E1.Salary < E2.Salary) n = nth highest salary.

Never got such a simple explanation, Thank you very much sir

Really well explained topics.. I got new interest in learning .. Thank you..

One of cross question asked by interviewer is, if more than one records having same 2nd higest salary, query in video gives only one record

I was asked this question yesterday in the interview.

So Nicely Explained sir..

Your training is excellent

Declare @N Int =2 Select EmployeeSalary From ( Select Dense_Rank() Over (Order By EmployeeSalary) SNo, EmployeeSalary From TblEmployee) temp Where SNo =@N

Very helpful. Thank you very much sir

Instead of row_number we can use dense_rank , bcoz if the table has duplicate 2nd highest salary and we nned to show both then it is not possible by row_number()

Fetch 1 offset n order by employeesalary should be the simplest way i think

Very nice explanation as asual

Bunch of thanks sir.🙏😊

very helpful, thank you.

Great content as always.

The video demonstrates well the idea but probably is not going to work if there are duplicated salaries in the table. To solve this group by the salary in the sub query. However using rank will be a better solution selecting the nth rank as the nth top salary. In places where top or rank is not available an insert into temp table with autooncrement first column and sequential select the nth row from it will do too.

In Oracle how can I find the same result. Top command will not work right?

use rank and select where rank = 1

the problem for me is that I don't want to get a job, because then I have to go to work... So I prefer to go unprepared to the interview, and then blame the company for xenofobia. High 5 !

I have paid to join the channel but still I am unable to get access to videos.

In PostgreSQL how to achieve?

Thank you so much Sir

CREATE FUNCTION getNthHighestSalary(@N INT) RETURNS INT AS BEGIN RETURN ( select distinct salary from Employee order by salary desc OFFSET @N-1 ROWS FETCH NEXT 1 ROWS ONLY ); END