Hi there!

Try this:
select CityID,
c.CityName,
ROW_NUMBER() OVER(ORDER BY c.CityName, c.CityID desc) AS RowID
from City AS c

So you can manage the multiple columns ordering too.

Bye!
Nyiti...