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
What are the different ways you can create databases in sql server?
Why we need sql server?
How to download and install microsoft .net framework version 2.0?
What command is used to create a database in the sql server and how?
What is an sql server agent?
What is model database in sql server?
What is replication with database mirroring? : sql server database administration
Why are sql functions used?
What is a ddl statement?
what's new in sql server 2016?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
Why and when do stored procedure recompile?
What are date and time data types in ms sql server?
Comment,Datatypes are unlimited
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration