SQL for ordering by number – 1,2,3,4 etc instead of 1,10,11,12

by

One way to order by positive integers, when they are stored as varchar, is to order by the length first and then the value:

order by len(registration_no), registration_no

This is particularly useful when the column might contain non-numeric values.

Note: in some databases, the function to get the length of a string might be called length() instead of len().

More Related Contents:

  1. Sort by column ASC, but NULL values first?
  2. SQL multiple column ordering
  3. MySQL: Alternatives to ORDER BY RAND()
  4. PostgreSQL DISTINCT ON with different ORDER BY
  5. ORDER BY the IN value list
  6. SQL best practice to deal with default sort order
  7. How to order by with union in SQL?
  8. Optimize query with OFFSET on large table
  9. When no ‘Order by’ is specified, what order does a query choose for your record set?
  10. How to use DISTINCT and ORDER BY in same SELECT statement?
  11. sql ORDER BY multiple values in specific order?
  12. SQL how to make null values come last when sorting ascending
  13. How to use Oracle ORDER BY and ROWNUM correctly?
  14. Sorting null values after all others, except special
  15. How do I return rows with a specific value first?
  16. SQL (ORACLE): ORDER BY and LIMIT [duplicate]
  17. Can I do a max(count(*)) in SQL?
  18. How to update and order by using ms sql
  19. How to ORDER BY a SUM() in MySQL?
  20. SQLite and custom order by
  21. Sorting string column containing numbers in SQL?
  22. SQL ORDER BY date problem
  23. “Order By” using a parameter for the column name
  24. Custom Order in Oracle SQL
  25. SQLite Order By Date1530019888000
  26. how does SELECT TOP works when no order by is specified?
  27. How to get results in a custom order? [closed]
  28. SQL ORDER chars numerically
  29. Dynamic order direction
  30. Curious issue with Oracle UNION and ORDER BY

Leave a Comment