Re: Row Number

add the column rownum.

ex

select col1, col2, col3, rownum
from yourTableName


On Mon, Jan 14, 2013 at 3:03 PM, joefootball_91 <[email protected]>wrote:

> **
>
>
> Is there a way to add a row number to a query? I want to use the row
> number as a unique id field. Is there a function similar to the
> ROW_NUMBER() that's available?
>
> I have a table named CUSTOMERS with fields titled FirstName and LastName.
> I want each row to have a unique number (the first row 1, the second row 2,
> third row 3, etc.) similar to the table below.
>
> ID FirstName LastName
> 1 xxxxx xxxxxx
> 2 xxxxx xxxxxx
> 3 xxxxx xxxxxx
> 4 xxxxx xxxxxx
> N xxxxx xxxxxx
>
> Thanks,
>
> Joe
>
>  
>



-- 
Gene L. Bradley Jr.
Software Developer I
Information Systems & Integration
Jackson State University
1400 J R Lynch Street
P.O. Box 17750
Jackson, MS 39217

ph 601.979.1042
fax 601.371.9146
email [email protected]