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
- 14088 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
Is oracle an open source?
How to do paging with oracle?
How to connect to a local oracle 10g xe server?
How to execute a stored procedure in oracle?
Why does Oracle not permit the use of PCTUSED with indexes?
How do I connect to oracle?
How to create an oracle database manually?
Explain the importance of .pll extension in oracle?
What is ASM (Automatic Storage Management) in Oracle?
How to drop a stored procedure in oracle?
How to start instance with a minimal initialization parameter file?
How to load data from external tables to regular tables?
How to delete multiple rows from a table in oracle?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
What is an Oracle Instance?
