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
- 14016 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
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
What is the use of group by clause?
What is the difference between grant and with grant while giving permissions to the user?
What is NOT NULL Constraint in sql server 2012?
What is RAID? What are the different types of RAID configurations?
Explain query editor regions
How to divide query output into multiple groups with the group by clause in ms sql server?
How do I get to sql server configuration manager?
How can we delete a table in sql server?
What is cte (common table expression)?
What do you understand by a view?
What are the tables in sql?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
Do you know what guidelines should be followed to help minimize deadlocks?
