Query for reorder a table in sql.

[Madelyn]

Hi All i need a query to re order the lines in DB.. Cuz when i try find a item is hard..
i have crazy numbers.. -.-
Example:

2
3
4
6
9
8
5
1

And need
1
2
3
4
5
6
7
8
9

Anyone? =(

[MentaL]

[123we]

USE ORDER BY "Row" ASC

Ex :

/****** Script for SelectTopNRows command from SSMS ******/
SELECT TOP 20 [CharName16]
,[CurLevel]
,[RemainGold]
FROM [SRO_VT_SHARD].[dbo].[_Char]
ORDER BY RemainGold DESC