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
- 14324 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / vamsi krishna
the reason behind this is rownum will be generated only
after selecting the row from the table.hence when you are
using inline views ,the outer select statement is having a
rownum and inner select statement is having a rownum,so due
to the ambiguity your query is not working.
i give the following change to ur query.
SELECT * FROM
(SELECT rownum as r1,TITLE FROM MOVIE )
WHERE r1 > 4;
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
How to save query output to a local file?
What are triggers in oracle?
How does Oracle guarantee data integrity of data changes?
Explain the function of optimizer in oracle?
How to create a new tablespace in oracle?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
What are the types of trigger in oracle?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
Explain the use of Merge statement in oracle 11g
How to handle a single quote in oracle sql?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
Which are the five query types available in oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
What is a private synonym?
is there a tool to trace queries, like profiler for sql server?
