Re: SQL question: automatically number rows returned by query

Hi,
think you can do the following:

 SELECT ROWNUM, col_1, col_2
 FROM my_table
 WHERE col_1 = 'X';

Greetings,
Thomas Plant

toddowers_at_my-deja.com schrieb:
>
> 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';
>
> 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.
Received on Tue Dec 07 1999 - 02:17:09 CST