SQL Order by fails

Question

How can I solve this little problem

here is a screenshot:

and this is the query:

SELECT * 
FROM serverinfo
ORDER BY rank_pts DESC 

As you can see the order is incorect.

Answer 1

You could try this:

ORDER BY CAST(rank_pts as float) DESC 

Answer 2

Seems your ranl_pts column is varchar type so it's not sorting as numbers.

Use below trick.

  SELECT * 
  FROM serverinfo
  ORDER BY rank_pts+0 DESC 

OR

 SELECT * 
  FROM serverinfo
  ORDER BY CAST(rank_pts AS DOUBLE) desc