在查询时尽量不要在sql内使用子查询, 将子查询改为关联查询 速度更快。
SELECT * FROM `dept_a` where id in (SELECT MAX(id) from dept_a GROUP BY source);
SELECT A.* from dept_a A
INNER JOIN (
SELECT MAX(id) id, source from dept_a GROUP BY source
) B on A.id = B.id
在查询时尽量不要在sql内使用子查询, 将子查询改为关联查询 速度更快。
SELECT * FROM `dept_a` where id in (SELECT MAX(id) from dept_a GROUP BY source);
SELECT A.* from dept_a A
INNER JOIN (
SELECT MAX(id) id, source from dept_a GROUP BY source
) B on A.id = B.id