mysql - 使用 SQL [mysql] 按天计算的总计

Question

我的表格如下:

datePickup           deliveryStatus    count 
2015-09-04 16:14:55  1                 NULL
2015-09-04 15:52:52  99                NULL
2015-09-04 12:47:55  2                 NULL
2015-09-05 06:14:55  99                NULL
2015-09-05 15:52:52  99                NULL
2015-09-05 17:47:55  99                NULL
2015-09-06 02:14:55  1                 NULL
2015-09-06 14:52:52  99                NULL
2015-09-06 17:47:55  99                NULL

如果交付状态为 99，我希望按天计算总交付量:

datePickup   count 
2015-09-04   1     
2015-09-05   3     
2015-09-06   2                 

Answer 1

将 GROUP BY 与 DATE() 一起使用:

SELECT DATE(datePickup), count(*)
FROM yourtable
WHERE deliveryStatus=99
GROUP BY DATE(datePickup);