| Help me to Know About Rownum [message #370405] |
Tue, 21 September 1999 08:58  |
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  |
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....
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
