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
- 10322 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 N salary from payroll..emp order by
salary desc)
if u want top 2 put 2 at the pacece of N
if u want top 5 put 5 at the pacece of N
if u want ..............................
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you clear a log file?
How is SQL Azure different than SQL server?
Why SQL Agent is used?
How to find tables without indexes?
What is the largest component inside a field?
Which sql server table is used to hold the stored procedure script?
What is ssl in sql server?
What is sql stored procedure?
what method you can use to reduce the overhead of Reporting Services data sources?
What is serializable?
what is normalization? Explain different levels of normalization? : Sql server database administration
What is the maximum size per database for sql server express?
What are the underflow and overflow behaviors on float literals?
What is the purpose of optimization?
Do you know what are acid properties of transaction?
