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
- 10329 Views
- I also Faced
- E-Mail Answers
Answer Posted / sridhar sahoo
select distinct top 1 salary from payroll..emp where salary
in(select distinct top 3 salary from payroll..emp order by
salary desc)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are different types of subquery?
What is the difference between the 2 operating modes of database mirroring?
How many types of local tables are there in sql server?
How to access the deleted record of an event?
Give the query of getting last two records from the table in SQL SERVER?
Can multiple columns be used in sql group by clause in ms sql server?
how to determine the service pack currently installed on sql server? : Sql server database administration
What are the different types of sub-queries?
Explain the use of containers in ssis?
What is the full form of ddl?
Mention what are the different types of ssrs reports?
What is executereader?
What are data driven subscriptions?
Is there any difference between primary key and unique with the not null condition?
What is the temp table?
