Interested to Buy Any Domain ? << Click Here >> for more details...
from the table display the 2nd highest salary?
and also the least 2nd salay?
- 8 Answers
- 10623 Views
- I also Faced
- E-Mail Answers
Answer Posted / soorai ganesh
SELECT 'Second Highest Salary Is ', MAX(Salary) FROM Employee WHere Salary < ( Select MAX(Salary) FROM Employee )
SELECT 'Second Least Salary Is ',MIN(Salary) FROM Employee WHere Salary > ( Select MIN(Salary) FROM Employee )
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What do you understand by recursive stored procedure?
How can we improve performance by using SQL Server profiler?
What is the purpose of optimization?
What is scheduled job and how to create it?
What is difference between join and natural join?
Explain the stored procedure?
what are different types of backups available in sql server? : Sql server database administration
what method you can use to reduce the overhead of Reporting Services data sources?
role of sql sever 2005 in database rather than any other database
Can you please explain the difference between primary keys and foreign keys?
What is difference statement and preparedstatement?
what is a transaction? : Sql server database administration
How do I trace a query in sql server?
What are horizontal and vertical scaling?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
