Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 14253 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 define an external table with a text file?
What are transaction isolation levels supported by oracle?
What is a cursor in oracle?
What are set operators?
What are the differences between interval year to month and interval day to second?
How to check database size in Oracle?
How to fetch the row which has the max value for a column?
What is bind variable in oracle 11g?
What is literal?
How to set a transaction to be read only in oracle?
How to list all tables in your schema?
How to export your connection information to a file?
What is not equal to in oracle?
Oracle
Define oracle database
