max选最新时间出现重复
select A.id, max(a.date), B.id ,max(B.date) from A JOIN B ON A.id=B.id group by A.id,B.idB表时间没有筛选跪求求大佬指导
没表的说明，只能猜了
select A.id, max(a.date), max(B.date) from A JOIN B ON A.id=B.id group by A.id
2021-06-29 10:56
2021-07-02 16:58
