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
- 14518 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 convert .db (extention) database file into .dmp (extention ) for oracle database ?
In which language oracle has been developed?
What do you mean by merge in oracle and how can we merge two tables?
Where is the export dump file located?
How to create a new table by selecting rows from another table?
What is set verify off in oracle?
How to convert a string to a date in oracle database?
What is clustered table in Oracle?
What is the string concatenation operator in oracle?
How to view the tablespaces in the current database?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
what is a Nested Loop join?
Explain the difference between replace() and translate() functions in oracle?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How to drop an existing table in oracle?
