Re: Row Number

Thanks!

--- In [email protected], "gene.l.bradley"  wrote:
>
> add the column rownum.
> 
> ex
> 
> select col1, col2, col3, rownum
> from yourTableName
> 
> 
> On Mon, Jan 14, 2013 at 3:03 PM, joefootball_91 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 gbradley@...
>




------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/