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
- 6 Answers
- 12179 Views
- TCS, I also Faced
- E-Mail Answers
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
How to rename an index in oracle?
Give the various rollback segment states.
What is the best way to do multi-row insert in oracle?
Explain what are the type of synonyms?
What is the order of defining local variables and sub procedures/functions?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How to connect to the server with user account: sys?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What is the difference between sharding and partitioning?
When do we use group by clause in a sql query?
Explain an exception?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How to start a new transaction in oracle?
Name the three major set of files on disk that compose a database in Oracle?
How to loop through data rows in the implicit cursor?
