This is the extension of the article of finding the second highest salary. Here we’ll see how to find the N-th highest salary. It is more generic version which is applicable for second highest also. Lets consider this employee table. DBMS Independent Way Here we’ll not use any DBMS specific keywords. This SQL query should … Continue reading “SQL Query to Find the N-th Highest Salary”
Tag: SQL
SQL Query to Find Second Highest Salary
Finding the second highest salary from an employee table is a classic SQL problem the job seekers often face in their interview. Database programmers also have to solve similar problem like finding Nth highest number from a table. Finding the maximum salary from an Employee table is trivial. But finding the second highest is a tricky … Continue reading “SQL Query to Find Second Highest Salary”