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
Difference between open_form and call_form in oracle.
What is a proxy object?
Explain about achiever in sql?
Can we convert a date to char in oracle and if so, what would be the syntax?
What is save point in oracle database?
How to export your own schema?
How to experiment a data lock in oracle?
what are the advantages of running a database in archive log mode?
What is object data modeling?
please explain.. DB architecture ...
Explain the truncate in oracle?
What is meant by recursive hints in oracle?
Is there an oracle sql query that aggregates multiple rows into one row?
How to login to the server without an instance?
Explain self joins in oracle?