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

what is cross join? : Sql dba

657

What is delimiter sql?

630

What is rank dense_rank and partition in sql?

648

What is insert command in sql?

628

What is the difference between a primary key and a clustered index?

612

What are reports usually used for?

670

what is online transaction processing (oltp)? : Sql dba

625

Who is the owner of mysql database?

639

What is duration in sql profiler trace?

667

How do I count records in sql?

619

explain what is mysql? : Sql dba

700

What is triggering circuit?

682

Is a secondary key the same as a foreign key?

587

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

1762

What is sql table?

623