from the table display the 2nd highest salary?
and also the least 2nd salay?
- 8 Answers
- 9090 Views
- I also Faced
- E-Mail Answers
Answer Posted / mehul
for 2nd highest salary
select max(salary) from employee where salary<(select max
(salary) from employee )
for 2nd least salary
select min(salary) from employee where salary>(select min
(salary) from employee )
i hope that will help you
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the difference between primary key and unique key? : sql server database administration
What are the 3 types of schema?
What do you mean by collation recursive stored procedure?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
What are data regions?
What are the differences between DDL, DML and DCL in SQL?
what protocol both networks use? : Sql server database administration
You want to implement the one-to-one relationship while designing tables. How would you do it?
What is temporal data type?
What is the difference between substr and charindex in the sql server?
Is sql server implemented as a service or an application? : Sql server database administration
What is field in algebra?
Can primary key be null?
What is difference between rownum and row_number?
How to find which stored procedure is currently running in sql server?
