SELECT * FROM
(SELECT TITLE FROM MOVIE ORDER BY RANK DESC)
WHERE ROWNUM > 4;
when i run the above query .it produces output as NO ROWS
SELECTED.why ?plz any one help me
Answer Posted / mohan
select * from movie where rownum>4(select title from movie
rank()over(order by title desc);
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do I uninstall oracle 11g?
Where do you use decode and case statements?
How many categories of data types?
Explain the use of online redo log files in oracle.
How to connect to a local oracle 10g xe server?
When do I need to use a semicolon vs a slash in oracle sql?
How to use group functions in the select clause using oracle?
What privilege is needed for a user to delete rows from tables in another schema?
How to login to the server without an instance?
What are the components of logical database structure in oracle database?
what is the difference between restoring and recovering?
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.
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
State the various uses of dbcc command?
What are the different types of partitions in oracle?