sql 嵌套select与关联select

作者：yan

嵌套select

EXPLAIN
SELECT
cp.prj_id,
cp.log_date,
cp.progress_value
FROM
cm_prodaily cp
WHERE
cp.log_date = (
SELECT
MAX(cp2.log_date)
FROM
cm_prodaily cp2
WHERE
cp2.prj_id = cp.prj_id
)

关联select

EXPLAIN
SELECT
cp.prj_id,
cp.log_date,
cp.progress_value
FROM
cm_prodaily cp,(select cp2.prj_id,max(log_date) log_date from cm_prodaily cp2 GROUP BY cp2.prj_id) cp3
where cp.prj_id=cp3.prj_id
and cp.log_date=cp3.log_date