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
- 10616 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
Do you know what is difference between index seek vs. Index scan?
When we should use @@error?
What are the types of lock supported by ?
What is a field name?
what does the automatic recovery do? : Sql server administration
If a stored procedure is taking a table data type, how it looks?
How to apply filtering criteria at group level with the having clause in ms sql server?
Why do we partition data?
Is oracle faster than sql server?
What is the exact numeric data type in sql?
how many layers of tcp/ip protocol combined of? : Sql server database administration
what information is maintained within the msdb database? : Sql server administration
What is the full meaning of dml?
Write SQL queries on Self Join and Inner Join.
What is a non equi join?
