please tell me the query to get details of the employee
having the second largest salary
- 11 Answers
- 11007 Views
- 247Customer, I also Faced
- E-Mail Answers
Answer Posted / devendra dwivedi
Select * from EmpTbl Where Salary = (Select Max(Salary) from
EmpTbl Where Salary < (Select Max(Salary) from EmpTbl)
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is the security model used in sql server 2005?
What is federation member?
what is an index? : Sql server database administration
What is table constraint?
How to manipulate data from one table to another table ?
How to add code to the existing article (using improve article)?
Do you know query execution plan?
What is replication with database mirroring? : sql server database administration
Explain the working of sql privileges?
what are the new features introduced in sql server 2000? : Sql server database administration
Explain system rowset functions?
What is serializable?
Write down the syntax and an example for create, rename and delete index?
What is delete query?
What are the three different part of rdl file explain them?
