更新时间: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