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
- 60247 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 is a with(nolock)?
Do you have any idea about the tcl commands?
How many primary keys are possible in a table?
What are the steps you will take to improve the performance of a poor performing query?
why would you use sql agent? : Sql server database administration
What is inner join? Explain with an example?
Can we store videos inside the sql server table?
Can you explain important index characteristics?
How can I know what locks are running on which resource?
How many types of schemas are there?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
How to create a Master database in SQL server ?
How real and float literal values are rounded?
Does sql server use java?
