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
14089 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 enable novalidate constraint.

1030

How to define an explicit cursor in oracle?

984

What are the various constraints used in oracle?

990

Explain an exception and its types?

1008

How to call a stored function in oracle?

948

What is Virtual Private Database in Oracle?

1014

How to write a query with a left outer join in oracle?

1000

What do you mean by merge in oracle and how can you merge two tables?

904

What is the fastest query method to fetch data from the table?

1290

What is primefaces used for?

1005

How many types of database triggers exist?

1063

Explain the use of full option in exp command.

1053

How to apply filtering criteria at group level in oracle?

985

What is oracle latest version?

1037

Differentiate between pre-select and pre-query?

1049