Post reply

sorting of a columns

  • November 4, 2016 at 10:11 am

    #315215

    Hi All,

    I have a table and I have a column that has data like below

    Tabl1

    col1

    Base

    1

    2

    3

    4

    I need to sort the table the following way:

    Col1

    4

    3

    2

    1

    Base

    How can I achieve this.

    any help will be appreciated.

  • November 4, 2016 at 10:24 am

    #1910647

    Use ORDER BY and CASE.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • November 4, 2016 at 12:35 pm

    #1910703

    I used isNumeric and than I could sort the column.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply