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
- 12180 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
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What is proxy method?
How to sort output in descending order in oracle?
How can I combine multiple rows into a comma-delimited list in oracle?
Why do we use bulk collect in oracle?
Why we use bulk collect in oracle?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How would you change old and new values in an insert, delete and update triggers?
What are joins, explain all types of joins?
How many types of tables supported by oracle?
What are the differences between date and timestamp in oracle?
How to import one table back from a dump file?
Explain joins in oracle?
Can we convert a date to char in oracle and if so, what would be the syntax?
How to work with data objects interactively?
