Mysql查询结果日期时间明智

Question

我试过这样这是我的查询

SELECT sloat_day, sloat_start_time 
FROM time_table 
WHERE sloat_day BETWEEN '2014-12-01' AND '2014-12-07' 
ORDER BY sloat_day, sloat_start_time ASC

我的输出低于

sloat_day   sloat_start_time
2014-12-01  6.30
2014-12-01  7.30
2014-12-01  18.30
2014-12-01  19.30
2014-12-02  6.30
2014-12-02  7.30
2014-12-02  18.30
2014-12-02  19.30
2014-12-03  6.30
2014-12-03  7.30
2014-12-03  18.30
2014-12-03  19.30
2014-12-04  18.30
2014-12-04  19.30
2014-12-05  7.30
2014-12-05  18.30
2014-12-05  19.30
2014-12-06  19.30
2014-12-07  7.30
2014-12-07  8.30
2014-12-07  18.30
2014-12-07  19.30

我想要如下所示的查询结果，我想在查询中更改以获取此输出，请帮助我

2014-12-01  6.30
2014-12-02  6.30
2014-12-03  6.30
2014-12-04  18.30
2014-12-05  7.30
2014-12-06  19.30
2014-12-07  7.30
2014-12-01  7.30
2014-12-02  7.30
2014-12-03  7.30
2014-12-04  19.30
2014-12-05  18.30
2014-12-07  8.30
2014-12-01  18.30
2014-12-02  18.30
2014-12-03  18.30
2014-12-05  19.30
2014-12-07  18.30

Answer 1

像这样更改 ORDER 子句中列的顺序。

SELECT sloat_day, sloat_start_time 
FROM time_table 
WHERE sloat_day BETWEEN '2014-12-01' AND '2014-12-07' 
ORDER BY sloat_start_time, sloat_day ASC

这样，查询将首先按 sloat_start_time 排序。