I think that the easiest way out of this is to add a identity column to our table, just an automatic counter(1,2,3...).
Tip, when data is repeating it self in a table you should have look at your database design. Perhaps "John" only should exists one time in the table described and the money figures should be placed in a new table called money/salary or something?
If we add one more field with Identity property it will be occupying some space in database. That means unwantedly we are using memory. In the case of Oracle this ROWID is inbilt of Row Property. Why the Microsot come accross with this..