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 is a PL/SQL code compiled?

671

Why self join is used in sql?

499

What is a unique constraint?

610

How do I edit a trigger in sql developer?

543

Is primary key clustered or nonclustered?

568

How to combine two stored procedures in sql?

595

Explain what is table in a database?

583

What are the set operators in sql?

560

What is data type in sql?

556

What is the full form of sql?

537

What is compilation error in pl sql?

506

What is primary and foreign key?

593

How is pl sql different from sql?

548

how do you know the version of your mysql server? : Sql dba

508

What are pl/sql cursors?

567