MYSQL要求|按天分组 [英] MYSQL request | GROUP BY DAY

问题描述

我有一张桌子:订单，需要发出请求并获得其他桌子. 我的数据库表:

I have a table: orders, and need to make a request and get other table. My DB table:

id  close
1   2012-05-29 03:11:15
2   2012-05-30 03:11:40
3   2012-05-31 03:12:10
4   2012-05-31 03:14:13
5   2012-05-31 03:16:50
6   2012-05-31 03:40:07     
7   2012-05-31 05:22:18
8   2012-05-31 05:22:22
9   2012-05-31 05:22:50
...

我需要发出请求并获取此表(按日期分组(关闭)):

I need to make a request and get this table (GROUP BY DAY(close)):

1   2012-05-29 03:11:15
2   2012-05-30 03:11:40
9   2012-05-31 05:22:50 /*This is a last record on this day (05-31)*/

谢谢！

如果我发出此请求:

SELECT id, close
FROM `orders`
GROUP BY DAY(close)
ORDER BY id ASC

我会得到这张桌子:

1   2012-05-29 03:11:15
2   2012-05-30 03:11:40
3   2012-05-31 03:12:10

推荐答案

尝试一下，即可.

SELECT 
    a.id,
    a.close
FROM
(
    SELECT 
        id,
        close
    FROM
        `orders`
    ORDER BY
        close DESC
) AS a
GROUP BY 
    DATE(a.close)
ORDER BY 
    a.id
ASC;

这篇关于MYSQL要求|按天分组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！