find out the third highest salary?
Answer Posted / karunakar varma
select a,sal from (select dense_rank() over (order by sal
desc) a,sal from emp) where a=3
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
what is the scenario where you take the database to NoArchivelog mode?
What are the oracle differences between nvl and coalesce
How can Oracle users be audited?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
Explain oracle left join with an example?
 What are the oracle DML commands possible through an update strategy?
What is an oracle database?
How to check the server version in oracle?
What are the different editions of oracle?
What is oracle in java?
what are steps for interface? where is exchange rate defined in which table?
Explain the use of ignore option in imp command.
What are the different windows events activated at runtime ?
Explain what are the advantages of views?