Re: SQL Question

For sybase, you can create a temp table with identity column which increment as row insert into the temp table. Finally, after insert your result set into the temp table, you can then select * from the #temptable.

select *, id_col=identity(5)
into #new_discounts
from discounts

select *
from #new_discounts
go

On Sat, 20 Jun 1998, js wrote:

> I am trying to figure out how to get a result set in which the row
> number is a column in the result set. For example, if I select n rows
> from a table, I need a column to contain 1 thru n. Optimally, the
> syntax needs to be ANSI standard SQL, but nearly any solution will do.
> Anyone have ideas?
>
> TIA
> JS
>
>
Received on Mon Jun 22 1998 - 00:00:00 CEST