SQL question: automatically number rows returned by query

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 Mon Dec 06 1999 - 16:33:28 CST