mysql 查询表的最大时间的数据

最新推荐文章于 2024-07-30 03:49:48 发布

weixin_30699741

最新推荐文章于 2024-07-30 03:49:48 发布

阅读量2.9k

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/duanqiao123/p/9118624.html

版权

SELECT * from
(SELECT MAX(a.update_date) as q ,a.monitoring_point_id from biz_monitoring_point_record a GROUP BY a.monitoring_point_id ORDER BY a.update_date DESC) as t1
LEFT JOIN biz_monitoring_point_record t2 ON t1.monitoring_point_id=t2.monitoring_point_id AND t1.q=t2.update_date

转载于:https://www.cnblogs.com/duanqiao123/p/9118624.html