Hi All
I need to sort values as below:
6A8
6A9
6A10
7A8
7A9
7A10
But at the moment it sort as follows
6A10
6A8
6A9
7A10
7A8
7A9
Any advices please. I used ORDER BY DEPT_ID ASC. But unable to get my expected output.
Thank You
...
Go to the complete details ...