| ROWNUM Select [message #7332] |
Thu, 05 June 2003 08:06  |
Sarah Harvey
Messages: 7
Registered: April 2003
|
Junior Member |
|
|
Hi All
Is it possible to select ROWNUM as a field? i.e. use it a the main select statement and return the individual value for each result returned?
Many thanks, Sarah
|
|
|
|
| Re: ROWNUM Select [message #7334 is a reply to message #7332] |
Thu, 05 June 2003 09:16  |
Mike T
Messages: 32
Registered: August 2002
|
Member |
|
|
yep, it's a pseudo column, so you can (pretty much) treat it as a normal column.
select rownum, field1, field2
from table
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
