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
- 14095 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
What is index in Oracle?
What is partitioned table in Oracle?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
How to convert numbers to characters in oracle?
What are the set operators union, union all, minus & intersect meant to do?
How to select some columns from a table in oracle?
What is a procedure in oracle?
Can we insert data in view oracle?
what is meant by magic query
how can db_files > maxdatafiles since db_files is for instance and the later is for database
How to list all indexes in your schema?
What is the difference between hot backup and cold backup in oracle?
How many file formats are supported to export data?
What is format trigger?
Explain do view contain data?
