I wrote the query in Oracle 9i.
================================================== =======
select rowid,rownum,name,roll from student where rownum<=50
MINUS
select rowid,rownum,name,roll from student where rownum<25
================================================== ========
it executes successfully and gives the 25th to 50th record.

But if we set in where clause "rownum=25" or "rownum>25",
it doesnt execute. From R&D I make conclusion that rownum only take "<" & "<=" among vast logical operators.
Can anybody tell the reason behind it.

Subhendu De
[email protected]
Software Developer
New Delhi, India

__________________
Subhendu De
[email protected]
Software Developer
New Delhi, India