Re: SQL query

On Thu, 18 Jan 2001 18:44:32 -0000, "Happy" <allan_at_livvy80.freeserve.co.uk> wrote:

>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
>
>

You can use RowNum

SELECT RowNum, Name FROM Color;

If you need an ORDER BY:

SELECT RowNum, Name FROM (SELECT Name FROM Color ORDER BY Name);

Brian Received on Thu Jan 18 2001 - 13:32:51 CST