Query to find 4th higesty salary

Question

Accepted Answer

Query to find 4th highest salary

Use the 'ROW_NUMBER' function to assign a rank to each salary
Order the salaries in descending order
Select the salary with rank 4

Accepted Answer

let us see with an example : To find 4th Highest salary query will be : Select Salary from table_name order by Salary DESC limit 3,1; Here we are skipping 3 rows from Top and returning only 1 row after skipping

Accepted Answer

Using , we get nth salary from Windows Functions (or) OLAP Functions.

Densrank() doesn't skip the ranking position.

Syntax:- select column_names, densRank() over(order by column_name) rn from table_name qualify=4

(or)

Example:-Employee table

select empID, empName, densrank() over(order by empID) rn from Employee qualify=4

(or)

Correlated subQuery:- first outer is executed after send to result, inner query where clause.

select * from emp e1 where (4-1)=(select count(disticnt(sal))) from emp e2 where e1.sal

Query to find 4th higesty salary

Top Globant DOT NET Developer interview questions & answers

Popular interview questions of DOT NET Developer

Top HR questions asked in Globant DOT NET Developer