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
- 14331 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 drop a tablespace?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How would you go about verifying the network name that the local_listener is currently using?
Does oracle charge for java?
What is meant by joins?
How to convert characters to times in oracle?
What are the arithmetic operations?
What is execute immediate in oracle?
What is MTTR advisor in Oracle?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
Give the various exception types.
How is it different from a normal table?
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?
Explain about functional dependency and its relation with table design?
