| Re: whynot>rownum? [message #19113] |
Thu, 28 February 2002 10:38 |
Zinni Jha
Messages: 1
Registered: February 2002
|
Junior Member |
|
|
Conditions testing for ROWNUM values greater than a positive integer are always
false. For example, this query returns no rows:
SELECT * FROM emp
WHERE ROWNUM > 1;
The first row fetched is assigned a ROWNUM of 1 and makes the condition false. The
second row to be fetched is now the first row and is also assigned a ROWNUM of 1
and makes the condition false. All rows subsequently fail to satisfy the condition, so
no rows are returned.
i know why but please tell me what is the work around?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
