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 to initialize variables with default values?
How do you find current date and time in oracle?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
How to get a list of all user accounts in the database?
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.
Explain the use of inctype option in exp command.
How to rename an index?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
Can I create users through internet explorer in oracle 10g?
What are the limitations oracle database 10g xe?
Use of an integrity constraint is better to validate data. Explain
How would you go about verifying the network name that the local_listener is currently using?
How do I limit the number of oracle database connections generated by weblogic server?
What is a system tablespace and when it is created?
How to revoke create session privilege from a user in oracle?