Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
- 35 Answers
- 59458 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / suhail
select top 1 salary from (select top 5 salary from
emp_table order by salary desc)temptable order by salary asc
| Is This Answer Correct ? | 17 Yes | 36 No |
Post New Answer View All Answers
What are orphan records?
Describe in brief databases and sql server databases architecture.
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
what are candidate key, alternate key and composite key? : Sql server database administration
What is the largest component inside a field?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
Give me any three differences between Truncate and Delete.
What is attribute hierarchy? : sql server analysis services, ssas
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
What are the different types of join?
What is the difference between osql and query analyzer?
What is nolock?
Explain how does the report manager work in ssrs?
Explain something about security and SQL Azure?
