on 2024 Oct 08 8:20 PM
I have an alphanumeric column with position values.
1.1.2 or 1.1.1.10 etc.
I would like to sort these as below. How do I do it in the best and smartest way?
1 |
1.1 |
1.1.1 |
1.1.1.1 |
1.1.1.1.1 |
1.1.2 |
1.1.2.1 |
1.1.3 |
1.1.3.1 |
1.1.4 |
1.1.4.1 |
1.1.5 |
1.1.5.1 |
1.1.6 |
1.1.6.1 |
1.1.7 |
just do a select with order by "your column", works like a charm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
72 | |
10 | |
10 | |
7 | |
7 | |
7 | |
7 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.