--获取时间上最新版本数据
SELECT * FROM ITEM_0 A
WHERE
NOT EXISTS(SELECT GUID FROM ITEM_0 C WHERE MD_ID=A.MD_ID AND A.UPDATETIME<UPDATETIME)
--and MD_ID IN(SELECT 新编码 from "Sheet3")
AND MD_ID like '1%'
ORDER BY MD_ID
--获取所有项目下的所有最新并已完成的里程碑任务
SELECT B.MD_ID 项目编号,B.MD_NAME 项目名称,B.PlanStartTime 项目计划开始时间，B.PlanFinishTime 项目计划结束时间,A.MD_ID 任务编号,A.MD_NAME 任务名称,
A.PlanStartTime 计划开始时间,A.PLANFINISHTIME 计划结束时间,A.ACTUALSTARTTIME 实际开始时间,A.ACTUALFINISHTIME 实际完成时间
,E.DESCRIPTION 执行状态
FROM PMTASK_0 A
LEFT JOIN PMPROJECT_0 B ON A.OWNERPROJECT=B.GUID
LEFT JOIN MA_CODE_DETAIL E ON E.GUID=A.EXECUTESTATUS
WHERE A.TaskType='99C18CD335A8454785247BDB8AD67DF2' AND E.DESCRIPTION='已完成'
AND NOT EXISTS(SELECT GUID FROM PMTASK_0 C WHERE C.OWNERPROJECT=A.OWNERPROJECT AND A.ACTUALFINISHTIME<C.ACTUALFINISHTIME)
--AND B.MD_ID='DP2022036'
ORDER BY B.MD_ID
