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
How to encrypt Strored Procedure in SQL SERVER?
Can we use where and having clause together?
Can we update data in a view?
What is key attribute?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
What is the Disadvantage of indexed sequential file.
Which is the best place or learning center for MS SQL?????In Bangladesh?????
What the different types of Replication and why are they used?
What are the results of running this script?
What are filegroups in sql server?
What are the different types of Indexes available in SQL Server?
Explain what is it unwise to create wide clustered index keys?
What is a trace frag?
How to loop through the result set with @@fetch_status?
Tell me extended events in sql server 2008?