sorting of a columns

• anjaliagarwal5

  Ten Centuries

  Points: 1267

  More actions

  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.

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  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

• anjaliagarwal5

  Ten Centuries

  Points: 1267

  More actions

  November 4, 2016 at 12:35 pm

  #1910703

  I used isNumeric and than I could sort the column.