please tell me the query to get details of the employee
having the second largest salary
- 11 Answers
- 12499 Views
- 247Customer, I also Faced
- E-Mail Answers
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 is wide table?
How many columns can exist together per table?
What are the types of containers in ssis?
How can we call UDF(User Define Function) using C# code in ASP.net ?
What are transactions and its controls?
How to reaname table name without using sp_Rename in sql server..?
Define magic tables in sql server?
Does a sql server 2005 select statement require a from?
Is null vs coalesce?
What is the use of =,==,=== operators?
Explain about the command-line tool SQLCMD?
How to use clusters?
What is a recursive stored procedure in sql server?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
What command would you use to create an index?
