Is there something similar to SQL 2005 row_number() in sql mobile?

hello,

    wondering if somone provide me sample select an
auto number query. example have table called people 2 columns first_name, , last_name. there isn't unique id correspond table dynamically make 1 during return of query.

i know possible in full version of sql 2005 using

select row_number() on (order last_name), first_name, last_name people

but within sql mobile there way?
so if there 5 rows in table return

1    john    alpha
2    john    beta
3    john    cat
4    john    delta
5    john    echo

john

no sql server mobile/everywhere edition not support row_number() , there no similar function :(

thanks,

laxmi

SQL Server  >  SQL Server Compact