Order by alphabet and then by numbers

7 votes

1 answer

24946 views

postgresql order-by sorting natural-sort

                          I have records like
 
     A5
     A4
     Z1
     B2
     C7
     C1A
     C11A
     B1
     B4

I want them to be sorted in this manner

    A4
    A5
    B1
    B2
    B4
    C1
    C11A
    C7
    Z1

using the ORDER BY clause.

I want them to be sorted by alphabets and then by numeric values.
                        

Asked by Abhishek (245 rep)

Oct 31, 2013, 08:29 AM
Last activity: Mar 5, 2015, 08:58 PM

Order by alphabet and then by numbers

Related Questions