please tell me the query to get details of the employee
having the second largest salary

Answer Posted / ram

SELECT TOP 1 ESAL
FROM
(
SELECT DISTINCT TOP 2 ESAL
FROM EMPLOYEE
ORDER BY ESAL DESC
)ABC
ORDER BY ESAL ASC

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does nvl stand for?

529


What are the advantages of user-defined functions over stored procedures in sql server?

445


What are the filtered indexes?

572


What stored by the model? : sql server database administration

519


How to use “drop” keyword in sql server and give an example?

669






How to create an index on a view?

558


what is normalization? : Sql server database administration

505


Can you explain what are various ways to enhance the ssrs report?

561


explain declarative management framework (dmf) in sql server 2008?

560


Difference between uniqe index and uniqe constraint?

521


What are the different types of cursor?

581


Suggest a method of joining two tables.

571


What samples and sample databases are provided by microsoft?

548


can you instantiate a com object by using t-sql? : Sql server database administration

496


Difference between drill down and drill through report.

521