第一张表。状态表:
ID Status Date
=======================
1 PRO 2010-02-10
1 LWR 2011-06-08
1 Active 2011-06-10
2 PRO 2010-02-10
2 LWR 2011-06-08
2 PRO 2011-06-10
3 PRO 2010-02-10
3 LWR 2011-06-08
3 APS 2011-06-10
第二张表。概况
ID Name
=========
1 Suba
2 Jhon
3 Felix
预期的输出。
ID Name Status Date
===============================
1 Suba Active 2011-06-10
2 Jhon PRO 2011-06-10
3 Felix APS 2011-06-10
如何从记录中获取最大最新日期值?
解决方案:
使用。
SELECT a.*
FROM YOUR_TABLE a
JOIN (SELECT t.id,
MAX(t.date) AS max_date
FROM YOUR_TABLE t
GROUP BY t.id) b ON b.id = a.id
AND b.max_date = a.date
本文来自投稿,不代表运维实战侠立场,如若转载,请注明出处:https://www.shizhanxia.com/849.html