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
- 14090 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 does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How different is ms access and oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
can anyody please send me the dump for Oracle 10g certifications for DBA path?
Explain the use of constraints option in exp command.
How to write a query with a left outer join in oracle?
What is raw datatype in oracle?
How to insert a new row into a table in oracle?
Explain index?
How to count duplicated values in a column in oracle?
How to find out what oracle odbc drivers are installed?
Explain oracle instance.
What is translate in oracle?
What does sharding mean?
Explain how are indexes update?
