This is a easy code but I am not able to figure it as Im fairly new to SQL.

Example I have a table like this-
Name: ID:
abcde 1
efghia 3
pofjsa 5
asklda 6

I want to sort the tables according to increasing ID.
Like this-
Name: ID:
abcde 1
efghia 2
pofjsa 3
asklda 4


Assuming that the ID's are continuously increasing but there are some ID's missing like 11,14,15,16,17,20,21.. etc

Thanks
Funny Reviewed by Funny on . SQL Help This is a easy code but I am not able to figure it as Im fairly new to SQL. Example I have a table like this- Name: ID: abcde 1 efghia 3 pofjsa 5 asklda 6 I want to sort the tables according to increasing ID. Rating: 5