Is There Something Similar To SQL 2005 Row_number() In Sql Mobile?

Hello,

I am wondering if somone could provide me with a sample SELECT for an
auto number query. For example I have a table called People with two columns first_name, and last_name. There isn't a unique id to correspond with the table but would like to dynamically make one during the return of the query.

I know this is possible in the full version of sql 2005 using

SELECT ROW_NUMBER() OVER (ORDER BY last_name), first_name, last_name from People

But within sql mobile is there a way?
So if there was 5 rows in the table it would return

1 John Alpha
2 John Beta
3 John Cat
4 John Delta
5 John Echo

John