Help me to Know About Rownum [message #370405] |
Tue, 21 September 1999 08:58 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Prashantha
Messages: 2 Registered: September 1999
|
Junior Member |
|
|
If I use rownum in my select statement
rounum = 1 or if I use (rownum #SomeNumber.
Update Me soon If you reson for this
Thanking you
Prashantha R india Mastech.
|
|
|
Re: Help me to Know About Rownum [message #370406 is a reply to message #370405] |
Tue, 21 September 1999 09:13 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
m a sivan
Messages: 34 Registered: July 1999
|
Member |
|
|
Because rownum is a runtime genrated variable whic starts from one always. So =1 is OK but = anything else would report a problem( but again u can get thru making it in asubquery) ad even order by clause distorts the ROWNUM....
|
|
|