且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

是否可以在 SQL Server 2008 中选择特定的 ORDER BY?

更新时间:2023-01-29 17:12:39

嗯.. 太糟糕了,日子被逐字存储为星期一"、星期二"等?

Hmm.. that's nasty, the days are stored as verbatim 'Monday', 'Tuesday', etc?

无论如何,就这样做:

SELECT * 
FROM Requirements
ORDER BY 
     CASE Day 
     WHEN 'Monday' THEN 1
     WHEN 'Tuesday' THEN 2
     WHEN 'Wednesday' THEN 3
     WHEN 'Thursday' THEN 4
     WHEN 'Friday' THEN 5
     WHEN 'Saturday' THEN 6
     WHEN 'Sunday' THEN 7
     END