Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6 Answers
- 14515 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / rachita
This is because you cannot use > operator with Top-N
Analysis.The operator which is used is only < less-then and
<= less-then-equal-to .You can also use = operator but only
for retrieving the top most value .
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
What is oracle and what are its different editions?
How to pass parameters to procedures?
Explain about functional dependency and its relation with table design?
What is save point in oracle database?
Explain the use of show option in imp command.
How to rename an existing table?
Why oracle is used?
How many types of segments in Oracle?
In oracle there is column command, how will you explain that?
What to do if dba lost the system password?
How to resolve name conflicts between variables and columns?
How index is implemented in oracle database?
does the query needs a hint to access a materialized view?
How to count duplicated values in a column in oracle?
what is the difference between restoring and recovering?
