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
- 61265 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 #table in sql server?
What are the steps you must follow to hide sql server instances?
In which files does sql server actually store data?
How do you rebuild an identity column?
Explain the rules for designing files and file groups in sql server?
How to convert binary strings into integers in ms sql server?
What is the return type of executeupdate ()?
What is partitioned view?
Explain the truncate command? : SQL Server Architecture
What is b tree index?
What is rs.exe utility?
can we have a nested transaction? : Sql server database administration
When a primary key constraint is included in a table, what other constraints does this imply?
Do you know what is sql service broker?
What is sql server profiler?
