In my database I've column fill this data:
1
1.1
1.1.1
1.1.1.1
1.1.2
1.10
1.11
1.2
1.9
I want to sort it, to get result looks like this:
1
1.1
1.1.1
1.1.1.1
1.1.2
1.2
1.9
1.10
1.11
How can I accomplish this? Simple use "ORDER BY" gives wrong result because it's lexicographic order.
Aucun commentaire:
Enregistrer un commentaire