Is there a way to have a value that increments by one in a SQL statement?

SELECT *, IncrementThisValueByOne FROM MyTable

To get:

MyFieldOne MyFieldTwo IncrementThisValueByOne

Bobby      Jones      1
Jamie      Lee        2
Terry      Hatcher    3