Re: SQL question: automatically number rows returned by query

From: Stanislav Benda <si_bendovi_at_hotmail.com>
Date: Mon, 06 Dec 1999 23:36:48 GMT
Message-ID: <82hhag$5tn$1@nnrp1.deja.com>

In article <82hdjo$36s$1_at_nnrp1.deja.com>, toddowers_at_my-deja.com wrote:
> Is it possible to automatically number the rows
> returned by a query?
>
> For example, suppose the following query returns
> 3 rows:
>
> SELECT col_1, col_2
> FROM my_table
> WHERE col_1 = 'X';

select rownum, col1, col2 from myTable;

> I would like to see the following result:
>
> row# col_1 col_2
> ---- ----- -----
> 1 X A
> 2 X B
> 3 X C
>
> In other words, I would like to automatically
> generate the row# column. Any thoughts?
>
> Thanks in advance for your help.
>
> Todd Owers
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 06 1999 - 17:36:48 CST