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
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