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

Why should I use oracle database?

975

What is catalog in Oracle?

1332

What happens to the data files if a tablespace is dropped?

1040

How to define a specific record type?

1072

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1925

Differentiate between translate and replace?

1083

What happens in oracle commit?

1002

How to handle a single quote in oracle sql?

1019

What is the usage of control file in oracle?

1071

What is recovery manager(rman) backup in Oracle?

1172

Explain the use of record length option in exp command.

1049

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1718

What is an oracle data file?

1083

What is the disadvantage of User defind function?

2270

Is primary key indexed by default in oracle?

967