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
- 12188 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / obed
You donot use '>4' for comparing
you must use '<=4'
if u used >4 its will not return any row because there in
no row is select >
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the restrictions on external table columns?
What is a relational database management system?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
How would you begin to troubleshoot an ORA-3113 error?
List out the difference between commit, rollback, and savepoint?
What is where clause in oracle?
How to define an explicit cursor in oracle?
What are the uses of synonyms?
How to get a list of all background sessions in the database?
Can we store pictures in the database and if so, how it can be done?
What is the sid in oracle?
does the query needs a hint to access a materialized view?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
What is rowid and rownum in oracle?
Explain alias?
