MSSQL – ORDER BY date with past dates after upcoming dates



SELECT *
FROM tableName
ORDER BY (CASE WHEN dateColumn < GETDATE()
              THEN 1
              ELSE 0
         END) DESC, dateColumn ASC








source: https://stackoverflow.com/questions/12365246/order-by-date-with-past-dates-after-upcoming-dates

 

This entry was posted on Monday, February 8th, 2021 at 8:36 pmand is filed under MSSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

Comments are closed.