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

List the various oracle database objects?

1061

How do I uninstall oracle client from windows?

1012

How to upsert (update or insert into a table)?

1005

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

1051

How to create a new view in oracle?

1078

How to display employee records who gets more salary than the average salary in the department?

1068

What is a table index in oracle?

1131

How to define a data field as not null?

1111

What is a private synonym?

1592

Explain mutating triggers.

1034

How to pass a parameter to a cursor in oracle?

1186

What is blob data type in oracle?

1123

Can we connect to ORACLE db using Windows Authentication?

1259

Hi Can any one tell me what are the API's used in requisition import.

1924

Explain cascading triggers.

1077