Answer Posted / arvind patil
select rownum,name,salary
from (select name,salary
from employee
order by salary desc )
where rownum=5;
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to use fetch statement in a loop?
What privilege is needed for a user to create views in oracle?
How will you identify oracle database software release?
What is the database name in oracle?
What is Library Cache in Oracle?
Explain what are the different type of segments?
What is concurrency in oracle?
How to assign query results to variables?
How to manage transaction isolation level?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What is flashback in Oracle?
How to change system global area (sga) in oracle?
How to omit columns with default values in insert statement in oracle?