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
14376 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

Explain a segment?

1095

How to list all indexes in your schema?

1106

What is an oracle?

1029

Can sub procedure/function be called recursively?

1013

What is the difference between sharding and partitioning?

1000

Explain about the analyze command in oracle?

1062

What is recovery manager(rman) backup in Oracle?

1198

What is Library Cache in Oracle?

1152

How to convert characters to times in oracle?

1031

What is oracle and what are its different editions?

1084

What is hash cluster in oracle?

1185

Give the advantages and disadvantages of clusters.

1059

What is a view and how is it different from a table?

1063

what are archived logs?

2207

How to write a query with an inner join in oracle?

1055