from the table display the 2nd highest salary?
and also the least 2nd salay?
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
How to create a simple user defined function in ms sql server?
What do you think of this implementation? Can this be implemented better?
Can a table have 2 foreign keys?
Explain ranking functions?
How do I view a stored procedure in sql server query?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
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
How to select true false based on column value in sql server?
What are the restrictions applicable while creating views? : SQL Server Architecture
Define msdb database?
Mention the 3 ways to get a count of the number of records in a table.
What is master database? : SQL Server Architecture
What is the purpose of linked server configuration in sql server?
What is the use of for clause?