please tell me the query to get details of the employee
having the second largest salary
- 11 Answers
- 12494 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
How to create new tables with "select ... Into" statements in ms sql server?
Does full backup break log chain?
What guidelines should be followed to help minimize deadlocks?
Tell me about joins in database system and explain each in detail.
When I run the sql server 2000 setup, it just hangs. What do I do?
What does the on delete cascade option do?
What is dirty read?
What is use of @@ spid in sql server?
Explain the difference between functions and stored procedures in sql server?
How to verify the port number of the sql server?
What is a data source file?
How do you test your database? : sql server database administration
What is default constraint in ms sql server?
How would we use distinct statement? What is its use?
What is Replication?
