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
- 10406 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
Why we need to use secondry database file? though, we can do same work using primary database file also.
What is a data source or ds? : sql server analysis services, ssas
Can sql servers link to other servers like oracle?
What is implicit cursors?
Explain throw statement in sql server 2008?
What are subqueries in sql server? Explain its properties.
How to set the current database in ms sql server?
What is updatable resultset?
Can you pass expressions to function parameters?
What is an example of a foreign key?
How to convert numeric expression data types using the cast() function?
What is a subquery in a select query statement in ms sql server?
Why we use functions in sql server?
What is table-valued sub query?
Explain the microsoft sql server delete command?
