SQL: ORDER BY using a substring within a specific column… possible?

by

You can put a CASE statement in the ORDER BY to accomplish this. A better route would be to change the application and table to actually store this relevant data in columns where it belongs when you have the development time to do that.

ORDER BY
    CAST(SUBSTRING(issue, 1, 4) AS INT) DESC,  -- Year
    CASE
        WHEN issue LIKE '%First_Quarter' OR issue LIKE '%Winter' THEN 1
        WHEN issue LIKE '%Second_Quarter' OR issue LIKE '%Spring' THEN 2
        WHEN issue LIKE '%Third_Quarter' OR issue LIKE '%Summer' THEN 3
        WHEN issue LIKE '%Fourth_Quarter' OR issue LIKE '%Fall' THEN 4
    END

Order the seasons however you want. You could also order them in a specific way (Q1 followed by Spring, followed by Q2, etc.) by adjusting the CASE statement.

More Related Contents:

  1. Natural Sort in MySQL
  2. SQL Query – Using Order By in UNION
  3. Humanized or natural number sorting of mixed word-and-number strings
  4. SQL how to make null values come last when sorting ascending
  5. Sorting null values after all others, except special
  6. A SQL Query to select a string between two known strings
  7. Dynamic Sorting within SQL Stored Procedures
  8. How to use SQL Order By statement to sort results case insensitive?
  9. How to Select a substring in Oracle SQL up to a specific character?
  10. Split String by delimiter position using oracle SQL
  11. Alphanumeric sorting with PostgreSQL
  12. Get the character between first 2 special character in SQL
  13. How Can I Sort A ‘Version Number’ Column Generically Using a SQL Server Query
  14. SQL Combine two rows into one
  15. SQL Server Subquery a
  16. SET NOCOUNT ON usage
  17. Oracle: how to UPSERT (update or insert into a table?)
  18. How can I get column names from a table in SQL Server?
  19. What exactly do quotation marks around the table name do?
  20. How can I get column names from a table in Oracle?
  21. What mysql database tables and relationships would support a Q&A survey with conditional questions? [closed]
  22. sqlite database default time value ‘now’
  23. MySQL remove duplicates from big database quick
  24. Is it possible to run native sql with entity framework?
  25. What are views good for?
  26. SQLite auto-increment non-primary key field
  27. T-SQL – Aliasing using “=” versus “as” [closed]
  28. Retrieve column names and types of a stored procedure? [duplicate]
  29. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  30. COALESCE Function in TSQL

Leave a Comment