Re: auto increment in select clause
From: Karel van der Walt <karelvdwalt_at_webmail.co.za>
Date: Fri, 7 Jun 2002 09:51:09 +0200
Message-ID: <adpom0$537$1_at_newnews.mikom.csir.co.za>
Date: Fri, 7 Jun 2002 09:51:09 +0200
Message-ID: <adpom0$537$1_at_newnews.mikom.csir.co.za>
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 - 09:51:09 CEST