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
- 12246 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
How to convert numbers to characters in oracle?
How different is ms access and oracle?
How to add another datafile to a tablespace?
How to write a left outer join with the where clause in oracle?
When system tablespace is created?
How to get the Installed Oracle Version Information ?
What is a nested table and how is it different from a normal table?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What is oracle datasource?
Explain oracle data types with examples?
How can we find out the duplicate values in an oracle table?
What do you know about normalization? Explain in detail?
How to loop through a cursor variable?
How do we create privileges in oracle?
what is the difference between functional dependecy and multilevel dependency?
