please tell me the query to get details of the employee
having the second largest salary
- 11 Answers
- 12493 Views
- 247Customer, I also Faced
- E-Mail Answers
Answer Posted / krishna mohan thamisetty
SELECT * FROM Emp e1
WHERE 2 = (SELECT COUNT(*) FROM Emp e2 WHERE e1.Salary <=
e2.Salary)
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
Write a query for primary key constraint with identity key word?
What is a covered index?
what are the different types of replication you can set up in sql server? : Sql server database administration
What is a collation?
Does view occupy space?
Explain indexed views and partitioned view with their syntax.
Explain nested trigger in sql?
Do you know the policy based administration feature of sql server 2008?
How do you handle datasets larger than 50 gb?
What is normalization? Explain different forms of normalization?
How to download microsoft sql server 2005 express edition?
Differentiate between mongodb vs. Sql server?
Explain transaction server distributed transaction?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What is difference between group by and having?
