please tell me the query to get details of the employee
having the second largest salary
- 11 Answers
- 10966 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
How to create an identity column?
List out the differences between the clustered index and non-clustered index in sql server?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
Why do we use stored procedures in sql server?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What are the different types of replication are there in sql server 2000?
Can foreign key be duplicate?
How to find the second highest salary of an employee?
What are the advantages to use stored procedures?
Do you know what are the ways available in sql server to execute sql statements?
What is the query and subquery?
What are pages and extents? : SQL Server Architecture
Explain the benefits of user-defined functions?
How do we Backup SQL Azure Data?
What are the different types of stored procedures?
