SELECT t.*
FROM (SELECT userid, max(starttime) as starttime FROM tn_sam_wear GROUP BY userid) a
INNER JOIN tn_sam_wear t
ON t.userid = a.userid and t.starttime=a.starttime
mysql 无限制子查询
最新推荐文章于 2023-10-05 20:18:25 发布
SELECT t.*
FROM (SELECT userid, max(starttime) as starttime FROM tn_sam_wear GROUP BY userid) a
INNER JOIN tn_sam_wear t
ON t.userid = a.userid and t.starttime=a.starttime