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
- 10117 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
How to delete duplicate rows in sql server?
How do I connect to sql server database?
When do you think a developer should use sql server-based cursors?
What does sql server mean?
What does asynchronous call backs means?
Which is faster statement or preparedstatement?
How to recompile stored procedure at run time?
How to find related tables in sql server?
Why we use trigger in sql server with example?
What is a filestream?
What is sleeping status in sql server?
what is blocking? : Sql server database administration
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
Why would you call update statistics?
What is row-level compre?
