Re: Numbering rows in SQL result set

[James Rich <james@xxxxxxxxxxx>]

On Wed, 5 May 2004 meovino@xxxxxxxxxxxxxxxxx wrote:

> Is there an SQL scalar function or some other trick I can use to add a
> column to a result set that numbers the rows in the set.  Let's say my
> result set currently is:

If you are reading the SQL results in a program just create a counter that
increments each time you retrieve a row.  You are probably doing this
already if you are using a multiple occurance DS.  If you aren't reading
the results in a program then obviously that won't work ;)

James Rich

Vs lbh guvax bs argjbex frphevgl nf na vzzhar flfgrz, Jvaqbjf vf UVI.
        -- Wbr Cyhgn