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
What does nvl stand for?
What are the advantages of user-defined functions over stored procedures in sql server?
What are the filtered indexes?
What stored by the model? : sql server database administration
How to use “drop” keyword in sql server and give an example?
How to create an index on a view?
what is normalization? : Sql server database administration
Can you explain what are various ways to enhance the ssrs report?
explain declarative management framework (dmf) in sql server 2008?
Difference between uniqe index and uniqe constraint?
What are the different types of cursor?
Suggest a method of joining two tables.
What samples and sample databases are provided by microsoft?
can you instantiate a com object by using t-sql? : Sql server database administration
Difference between drill down and drill through report.