auto increment in select clause

Hello.

I'd like to know how if it is possible to have an auto incremented column in a select clause, like this :

inc | ref

1     |       AAE
2     |       ADE
3     |       A3D

where the inc column is generated on the fly.

Thanks in advance. Received on Thu Jun 06 2002 - 16:00:13 CDT