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
- 14329 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 a package ? What are the advantages of package ?
How to drop a tablespace?
what are steps for interface? where is exchange rate defined in which table?
6. Display the client name and order date for all orders using the traditional method.
What do database buffers contain?
What is oracle thin client?
Explain rename?
What is Reduced List of Values?
What are the ansi data types supported in oracle?
Explain the difference between a procedure and a function? What do you understand by those terms?
Explain the use of inctype option in exp command.
How to get a list of all user accounts in the database?
Why packages are used in oracle?
How will you differentiate between varchar & varchar2?
How can I see all tables in oracle?
