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
- 10408 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 is datawarehouse?
What is the use of sign function?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
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?
How to write an inner join with the where clause in ms sql server?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
How to filter out duplications in the returning rows in ms sql server?
What is meant by dirty read?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
Is the primary key column of a table an index in ms sql server?
What is tablix?
How do I find the port number for sql server?
In which files does sql server actually store data?
What is the use of =,==,=== operators?
What are the advantages of using third-party tools?
