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
- 14252 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
How many anonymous blocks can be defined?
Why do we use coalesce function in oracle?
What is ASM (Automatic Storage Management) in Oracle?
Explain an exception and its types?
How to turn on or off recycle bin for the instance?
What are the differences between char and varchar2 in oracle?
What is the difference between a primary key & a unique key?
What happens if you lost a data file?
What is the difference between postgresql and oracle?
What are the attributes that are found in a cursor?
What is the meaning of recursive hints in oracle?
How to retrieve data from an explicit cursor?
How to write numeric literals in oracle?
What is a database table in oracle?
What are the different types of modules in oracle forms?
