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 / vamsi krishna
the reason behind this is rownum will be generated only
after selecting the row from the table.hence when you are
using inline views ,the outer select statement is having a
rownum and inner select statement is having a rownum,so due
to the ambiguity your query is not working.
i give the following change to ur query.
SELECT * FROM
(SELECT rownum as r1,TITLE FROM MOVIE )
WHERE r1 > 4;
Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
What is recycle bin in Oracle?
What is merge statement used for?
How to use "out" parameter properly?
what is the difference between data migration and production migration.
please explain.. DB architecture ...
Describe an oracle table?
What are the various constraints used in oracle?
How to get a create statement for an existing table?
How to connect ms access to oracle servers?
Hi Can any one tell me what are the API's used in requisition import.
Explain a segment?
What is define in oracle?
definition of cluster and non-clustered index?
What is an oracle?
What is an Oracle index?