Hi,
I would like to select and also give numbering in each record.
Let say I have table 'City' with a 'cityname' column
what is the select statement so I can get result records like this
no cityname
---- --------------
1 NEW YORK
2 LOS ANGELES
3 HOUSTON
4 ....
5 ...
Thank you.
Yudie