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
- 59374 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / savita vishwakarma
select max(sal)
from (select rownum
from emp
order by sal desc)
where rownum=2
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
Can we join two tables without primary key?
What is transaction server distributed transaction?
What is deploy, process and build? : sql server analysis services, ssas
How do you delete duplicate records in sql server?
How to insert data into an existing table?
What are information schema views?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
How do you delete duplicate rows in sql server?
what's the maximum size of a row? : Sql server database administration
Do you know what is rank function?
Explain identity in sql server?
What does executeupdate return?
Tell me what is the stuff and how does it differ from the replace function?
What do you mean by 'normalization'?
Explain difference between control flow and data flow?
