Home » RDBMS Server » Server Administration » Help me to Know About Rownum
Help me to Know About Rownum [message #370405] Tue, 21 September 1999 08:58 Go to next message
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
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....
Previous Topic: Oracle-Sql
Next Topic: Re: simple query
Goto Forum:
  


Current Time: Fri Mar 29 05:42:23 CDT 2024