使用MAX(signin)按ID分组的汇总。这将列出signin每个最新的id。
SELECT
id,
MAX(signin) AS most_recent_signin
FROM tbl
GROUP BY id
要获取完整的单个记录，请INNER JOIN对仅返回MAX(signin)每个ID 的子查询执行。
SELECT
tbl.id,
signin,
signout
FROM tbl
INNER JOIN (
SELECT id, MAX(signin) AS maxsign FROM tbl GROUP BY id
) ms ON tbl.id = ms.id AND signin = maxsign
WHERE tbl.id=1
602392714
清零编程群