试试这个查询-
SELECt t1.* FROM foo t1 JOIN (SELECt uid, MAX(id) id FROM foo GROUP BY uid) t2 ON t1.id = t2.id AND t1.uid = t2.uid;
然后使用EXPLAIN分析查询。
SELECt t1.* FROM foo t1 LEFT JOIN foo t2 ON t1.id < t2.id AND t1.uid = t2.uidWHERe t2.id is NULL;
试试这个查询-
SELECt t1.* FROM foo t1 JOIN (SELECt uid, MAX(id) id FROM foo GROUP BY uid) t2 ON t1.id = t2.id AND t1.uid = t2.uid;
然后使用EXPLAIN分析查询。
SELECt t1.* FROM foo t1 LEFT JOIN foo t2 ON t1.id < t2.id AND t1.uid = t2.uidWHERe t2.id is NULL;
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
