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
- 14085 Views
- TCS, I also Faced
- E-Mail Answers
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
What is index in Oracle?
How to use windows user to connect to the server?
How to create a new user account in oracle?
How to start a new transaction in oracle?
How to get maxsal , minsal, ename department wise in single query
Explain constraining triggers.
How to divide query output into groups in oracle?
How to use like conditions in oracle?
List out the components of logical database structure of oracle database.
Explain compound trigger in oracle?
What privilege is needed for a user to query tables in another schema?
What are the varoius components of physical database structure of oracle database?
Why is oracle used?
How do I find the database name in oracle?
What is an oracle?
