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 convert csv to table in oracle?
Which is better Oracle or MS SQL? Why?
What are the components of logical database structure in oracle database?
Is it possible to split the print reviewer into more than one region ?
How to get execution statistics reports on query statements?
How to pass a parameter to a cursor in oracle?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
How to check database size in Oracle?
Difference between inner join vs where ?
How to define default values for formal parameters?
What is a view and how is it different from a table?
How to start your 10g xe server?
What is a cursor and what are the steps need to be taken?
definition of cluster and non-clustered index?
How to bring a tablespace offline?