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
- 60237 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
How to create an multi-statement table-valued function?
Is sql server free?
What are the different types of collation sensitivity in sql server?
Explain different types of index?
Can you always create a cache of a report?
How to create view in stored procedure sql server?
is there a column to which a default can't be bound? : Sql server database administration
how you can configure a running aggregate in SSRS?
How to add code to the existing article (using improve article)?
What is PROJECTION Operation?
Explain how to maintain a fill factor in existing indexes?
Explain atomicity?
What is catalog views?
How to insert multiple rows with one insert statement in ms sql server?
How to find the list of fixed hard drive and free space on server?
