select * from movie where rownum>4(select title from movie rank()over(

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 / mohan

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

Answer Posted / mohan

select * from movie where rownum>4(select title from movie
rank()over(order by title desc);

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the usage of analyze command in oracle?

1141

Give the different types of rollback segments.

1080

What is a nvl function?

1097

Is insert autocommit in oracle?

1134

How to convert dates to characters in oracle?

1093

IS it possible to built the oracle database without setting the kernal parameters?

2397

What are the attributes of cursor?

1105

What are triggers in oracle?

1099

Can you tell me how to add new column in existing views?how?How is possible?

1515

Name the various constraints used in oracle?

1080

How to define an anonymous procedure with variables?

1242

How to rename an index in oracle?

1172

Why does Oracle not permit the use of PCTUSED with indexes?

2479

Can multiple cursors being opened at the same time?

1117

What is an oracle tablespace?

1096