SELECT t1.*FROM tbl AS t1 INNER JOIN (SELECT tbl.userId, MAX(date) AS lastDate FROM tbl GROUP BY tbl.userId) AS t2 ON t1.userId = t2.userId AND t1.date = t2.lastDate
此内容由惯性聚合(RSS阅读器)自动聚合整理,仅供阅读参考。 原文来自 — 版权归原作者所有。