Re: Row Number

I know I suggested rownum and I has used it successfully in queries, if you
merely need each row to have a unique identifier, the function you want is
row_id.
iT IS HEX NON DISPLAY. So to see it you will have to turn that feature on
in your editor. Or you can concatenate the record key/id to it.


On Mon, Jan 14, 2013 at 3:10 PM, Joseph Charpak
<[email protected]>wrote:

> **
>
>
> On 01/14/2013 04: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
>
>   Research the rank() function. There's also rownum but that wont do what
> you want (it's borderline useless)
>
>  
>



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