SELECT TOP 1 * FROM [SELECT TOP 3 * FROM Emp_Salary ORDER BY Salary DESC;]

how to check the 3rd max salary from an employee table?

Question Posted / neeraj

Answer Posted / neeraj

SELECT TOP 1 * FROM [SELECT TOP 3 * FROM Emp_Salary
ORDER BY Salary DESC;]
ORDER BY Salary;

Is This Answer Correct ?

3 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How to order siblings in oracle hierarchy queries?

1111

What are the string functions in sql?

1023

What is difference between cursor and trigger?

1129

What are the operators used in select statements?

1100

Is sql an operating system?

1075

what is the stuff function and how does it differ from the replace function? : Sql dba

1108

How do I find duplicates in sql?

982

Write a sql query to get the third highest salary of an employee from employee_table?

1119

Do we need to rebuild index after truncate?

1098

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1067

What is pivot in sql?

973

what is myisam? : Sql dba

1160

What is the purpose of normalization?

1086

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1273

How do you delete a table?

1124