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
- 14325 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
How to convert raw data type into text in oracle? Explain
What are the varoius components of physical database structure of oracle database?
how to make an oracle object
How many types of database triggers exist?
How to lock and unlock a user account in oracle?
How can you use check constraints for self referential integrity?
Give the different types of rollback segments.
How do I manually create a database in oracle?
How to establish administrator authentication to the server?
How to create an oracle database?
What is tns name?
What do you understand by database schema and what does it hold?
How to get a list of all user accounts in the database?
Explain mutating triggers.
Why do we need integrity constraints in a database?
