SQL query

Is it possible in SQL to display the contents of a table in a particular order, along with
a numeric column that shows the sequence of each row?

For example, a table with one column, color, has the following 3 values:

Green
Blue
Red

Say I wanted the alphabetic listing along with the numeric sequence,

1 Blue
2 Green
3 Red

Can it be done?

Cheers
Allan Received on Thu Jan 18 2001 - 12:44:32 CST