MySQL 选择每天最后一行按日期 DESC 排序 [英] MySQL select every day last row orderered by date DESC

问题描述

我有数据，

Stamp                dataField1 dataFiel2
2012-05-23 23:59:59  ....        ....
2012-05-23 23:50:00  ....        ....
2012-05-24 24:43:23  ....        ....
2012-05-24 24:12:10  ....        ....
2012-05-25 25:15:00  ....        ....
2012-05-26 25:53:59  ....        ....

我想每天选择最后一行，结果应该是 li

and i want to select every day last row and result should look li

Stamp                dataField1 dataFiel2
2012-05-23 23:59:59  ....        ....
2012-05-24 24:43:23  ....        ....
2012-05-26 25:53:59  ....        ....

推荐答案

这个怎么样?

SELECT MAX(Stamp) as Stamp, dataField1, dataField2
FROM tableName
GROUP BY DAYOFYEAR(Stamp)

我会说使用 DAYOFYEAR 代替 DAY 正如大家所说.有关差异，请参阅以下链接.

在这个演示中，DAY 给出了 3 行 INCORRECT 与使用 DAYOFYEAR 的 4 行相反.

In this demo, DAY gives 3 rows which is INCORRECT as oppose to 4 rows using DAYOFYEAR.

这篇关于MySQL 选择每天最后一行按日期 DESC 排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！