Interested to Buy Any Domain ? << Click Here >> for more details...
please tell me the query to get details of the employee
having the second largest salary
- 11 Answers
- 14854 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
What is difference between rownum and rowid?
Does windows server 2016 come with sql server?
Which is the main third-party tool used in sql server?
Distinguish between nested subquery and correlated subquery?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
How to download microsoft sql server 2005 express edition?
What is a trigger and types of a trigger?
What are the restraints imposed on the table design by a merge replication?
what is dbcc? : Sql server database administration
What is the purpose of sql profiler in sql server? : sql server database administration
What is difference between unique and primary key?
Explain the steps needed to create a scheduled job?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
How do you know if sql server is running on your local system?
How do you send email on SQL Server?
