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
- 12222 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
When do you get a .pll extension in oracle? Explain its importance
Difference between open_form and call_form in oracle.
What do you understand by a database object?
What is a database table in oracle?
Explain a synonym?
How to create lov dynamically at runtime & attach to text field?
How to install oracle odbc drivers?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Why oracle is used?
How to drop an existing view in oracle?
Is it possible to split the print reviewer into more than one region ?
How to retrieve data from an explicit cursor?
How to convert dates to characters in oracle?
How to delete a user account in oracle?
How do you tell what your machine name is and what is its IP address?
