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
- 14364 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 specify default values in insert statement using oracle?
How to upsert (update or insert into a table)?
How to use "in out" parameter properly?
List the parts of a database trigger.
How to check database size in Oracle?
What is a database table in oracle?
How to create a table in a specific tablespace?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
Explain cascading triggers.
How do you find current date and time in oracle?
What is a select query statement in oracle?
How to define a data source name (dsn) in odbc manager?
How do I escape a reserved word in oracle?
What are oracle functions?
What are the logical operations?
