You donot use '>4' for comparing you must use '<=4�

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

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

Answer Posted / obed

You donot use '>4' for comparing
you must use '<=4'
if u used >4 its will not return any row because there in
no row is select >

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Difference between pre-select and pre-query

1081

Explain oracle 12c new features for developers?

1024

What is MTTR advisor in Oracle?

1077

How to generate query output in html format?

1095

How to grant create session privilege to a user in oracle?

975

What is system tablespace?

1077

How to shutdown your 10g xe server from command line?

1067

What is an Oracle Instance?

1105

How to specify default values in insert statement using oracle?

1084

How remove data files before opening a database?

1049

How to turn on or off recycle bin for the instance?

1053

How to start a new transaction in oracle?

1064

Describe the types of sub query?

980

When do you get a .pll extension in oracle?

1127

Â What are the oracle DML commands possible through an update strategy?

1042