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
- 14248 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 a trigger oracle?
State the various uses of dbcc command?
How to get the Installed Oracle Version Information ?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What is coalesce function?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What is meant by raw datatype?
How to use "in out" parameter properly?
Explain an index?
Why packages are used in oracle?
How to delete an existing row from a table in oracle?
What are the different oracle database objects?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
Describe an oracle table?
What is a proxy object?
