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
- 14330 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 IDE,DMV in sql server?
How do I recompile a procedure in oracle?
How many memory layers are in the oracle shared pool?
What is oracle sid?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
what is insert all statement in sql
How many anonymous blocks can be defined?
What is an oracle cursor variable?
How to assign values to variables?
Can we create database in oracle using command line ?
Does oracle database need java?
interview questions with answer for cts
How to create a new table by selecting rows from another table?
What happens to the current transaction if a ddl statement is executed?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
