RE: Numbering rows in SQL result set

["Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Select rrn(a), name from greatOnes a order by 1;

will give you the relative record numbers in order. Not quite what you
wanted but...

-----Original Message-----
 Subject: Numbering rows in SQL result set

Is there an SQL scalar function or some other trick I can use to add a 
column to a result set that numbers the rows in the set.  Let's say my 
result set currently is:

John
Paul
George
Ringo

I want it to look like:

1   John
2   Paul
3   George
4   Ringo

Thanks!

Mike E.