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
Answer Posted / dinesh a.
you can't use rownum > 4 ( you can use only rownum <
clause). not in inner query or inline view even in normal
query.
select empno from emp where rownum > 5 ..
The output you will get NO ROWS always ....
so the magic is only order by clause asc or desc pls see
below
suppose we have a table x with one column col1 and values
are 1 to 10...
SELECT rownum,rank,col1 FROM
(SELECT rownum rank,col1 FROM x ORDER BY col1 desc)
WHERE ROWNUM <= 6 /* last six rows mean > 4 */
/
ROWNUM RANK COL1
------ ---------- ----------
1 10 10
2 9 9
3 8 8
4 7 7
5 6 6
6 5 5
1 SELECT rownum,rank,col1 FROM
2 (SELECT rownum rank,col1 FROM x ORDER BY col1 asc)
3* WHERE ROWNUM <= 4 /* first 4 rows */
SQL> /
ROWNUM RANK COL1
---------- ---------- ----------
1 1 1
2 2 2
3 3 3
4 4 4
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How will you identify oracle database software release?
What is a trigger and what are its types in oracle?
What is an oracle cursor variable?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
How to export your own schema?
How can you merge two tables in oracle?
Difference between cartesian join and cross join?
What are the system predefined user roles?
List the types of joins used in writing subqueries?
How to drop a stored function?
How to list all indexes in your schema?
What is oracle update statement with inner join ?
How to use existing values in update statements using oracle?
Where is the export dump file located?
State the difference between a primary key and foreign key?