Are you trying to do something like this?

Select ROW_NUMBER() OVER(ORDER BY FirstName, LastName) AS RowNumber, FirstName, LastName

Output

RowNumber FirstName LastName

1 Joe Smith

2 Joe Thomas

3 Joe Williams