SQL sort by version “number”, a string of varying length

by

In PostgreSQL you can do:

SELECT * FROM Requirements
ORDER BY string_to_array(version, '.')::int[];

This last ::int[] makes it convert string values into integers and then compare as such.

More Related Contents:

  1. Syntax not valid on word ‘ON’ in SQL join statement [closed]
  2. Select first row in each GROUP BY group?
  3. Optimal way to concatenate/aggregate strings
  4. What is an index in SQL?
  5. Doing a WHERE .. IN subquery in Doctrine 2
  6. Escaping keyword-like column names in Postgres
  7. SQL left join vs multiple tables on FROM line?
  8. TSQL Pivot without aggregate function
  9. Delete duplicate rows (don’t delete all duplicate)
  10. Why are there gaps in my IDENTITY column values?
  11. What is the reason not to use select *?
  12. GROUP BY + CASE statement
  13. Return a value if no record is found
  14. How do I return rows with a specific value first?
  15. How to count occurrences of a column value efficiently in SQL?
  16. Perform this hours of operation query in PostgreSQL
  17. Does the JDBC spec prevent ‘?’ from being used as an operator (outside of quotes)?
  18. Search for “whole word match” with SQL Server LIKE pattern
  19. How to use an ALIAS in a PostgreSQL ORDER BY clause?
  20. How to get N rows starting from row M from sorted table in T-SQL
  21. Is there a difference between Select * and Select [list each col] [duplicate]
  22. How can I generate a temporary table filled with dates in SQL Server 2000?
  23. Why are logical reads for windowed aggregate functions so high?
  24. Is SQL or even TSQL Turing Complete?
  25. MySQL’s alternative to T-SQL’s WITH TIES
  26. SQL SELECT from multiple tables
  27. Can select * usage ever be justified?
  28. Finding rows that don’t contain numeric data in Oracle
  29. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  30. What is the meaning of SELECT … FOR XML PATH(‘ ‘),1,1)?

Leave a Comment