Dear Experts

I have this select statement

select name,country from mytable order by name into cursor xyz

It displays following data

Abc----India
Bush---Germany
Eric---japan

I want to show display (record number) serial number in other column as

1---Abc------India
2---Bush---Germany
3---Eric------japan

Please help