Re: auto increment in select clause

what you want is just a sequence number

a self join with count() will give you 'rank' but it gets slow soon with queries returning many rows.

"Samuel Tribehou" <s.tribehou_at_wanadoo.fr> wrote in message news:adoigq$d7r$1_at_wanadoo.fr...
> 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 Fri Jun 07 2002 - 02:51:09 CDT