Re: Row Number

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)