posted 16 years ago
Prashanth,
If I remember correctly, Oracle only allows less than or equal to logical operators with rownum pseudo-column.
Hence your query using greater than operator does not work.
I'm only guessing, but I think you may be able to use the "between" operator, as in:
Good Luck,
Avi.