find out the third highest salary?
Answer Posted / alka
select min(salary)
from(select salary
from emp
order by salary desc
)
where rownum <=3
| Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
What is an oracle user account?
Difference between inner join vs where ?
How to get last row id?
How to assign data of the deleted row to variables?
Which are the five query types available in oracle?
What is enter substitution variable in oracle?
Can we save images in a database and if yes, how?
What are operators in oracle?
How to convert raw data type into text in oracle? Explain
Explain what are the uses of rollback segment?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How many types of table in Oracle?
Explain how are indexes update?
What is the minimum client footprint required to connect c# to an oracle database?