You donot use '>4' for comparing you must use '<=4�

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

Question Posted / obed

6 Answers
14525 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / obed

You donot use '>4' for comparing
you must use '<=4'
if u used >4 its will not return any row because there in
no row is select >

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to create a testing table in oracle?

1037

Why packages are used in oracle?

1119

How to download oracle database 10g xe?

1068

How to use subqueries with the exists operator in oracle?

1071

What is partitioned table in Oracle?

1272

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1129

State all possible different index configurations a table can possibly have?

1104

How to select an oracle system id (sid)?

1123

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1089

What are the different editions of oracle?

1180

How to run queries on external tables?

1088

interview questions with answer for cts

2638

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4415

What is dual table oracle?

1030

What is recovery manager(rman) backup in Oracle?

1232