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 / imran raza
ORDER BY Clause inside Inline View is not permissible.So in
query (SELECT TITLE FROM MOVIE ORDER BY RANK DESC)it should
be only SELECT TITLE FROM MOVIE .
Moreover Order by can be used by specifying the name (
selected row) of coloumn in order by clause.
Instead of names numbers can also be used.ie Order by 1.
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is oracle and what are its different editions?
What is an oracle transaction?
Explain enable novalidate constraint.
How do I connect to oracle?
What is the difference between a hot backup and a cold backup in oracle?
What is the order of defining local variables and sub procedures/functions?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
What is Java Pool in Oracle?
Explain the use of consistent option in exp command.
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
Why do we need oracle client?
How to list all user accounts in oracle?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
Please explain oracle data types with examples?