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
- 10321 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
Does partitioning help performance?
What is oltp (online transaction processing)?
How to apply cascading referential integrity in place of triggers?
What is an indexed view?
Explain about sql server login?
What is dbcc command in sql server?
How many ways to create table-valued functions?
What happens on checkpoint?
What is service broker?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Why I am getting this error when dropping a database in ms sql server?
What is raiseerror? What is raiseerror?
Explain differences between web edition and business edition?
What is temporal table?
What is identity?
