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
- 12231 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / mohan
select * from movie where rownum>4(select title from movie
rank()over(order by title desc);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to add another datafile to a tablespace?
Explain what are the characteristics of data files?
What is a cursor variable?
What privilege is needed for a user to create tables in oracle?
What is the use of aggregate functions in oracle?
What is analyze command used for?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
How to execute a stored program unit?
How to add a new column to an existing table with a default value?
Explain about the analyze command in oracle?
How to do paging with oracle?
How to run the anonymous block again?
What are set operators?
Does oracle database need java?
What are the logical operations?
