RE: OT: (cross post) SQL row numbering

ECTED]] Sent: Monday, February 03, 2003 3:06 PM To: CF-Talk Subject: Re: OT: (cross post) SQL row numbering Matthew Small wrote: > How can I get SQL server to automatically number my rows of a > recordset, as I retrieve it? > > If I have the following information in a table (exampl

Re: OT: (cross post) SQL row numbering

Matthew Small wrote: > How can I get SQL server to automatically number my rows of a recordset, > as I retrieve it? > > If I have the following information in a table (example data) > > NameAge > Joe 20 > Sally 14 > Jim 15 > > And I do a query: > > Select somefunction() as r