SELECT
*
FROM
`project_stage` `b`
WHERE
(
NOT (
EXISTS (
SELECT
1
FROM
`project_stage` `a`
WHERE
((
`b`.`Project_Code` = `a`.`Project_Code`
)
AND ( `a`.`Insert_Time` > `b`.`Insert_Time` )))))
ORDER BY
`b`.`Insert_Time` DESC;
select * from monitor_warn_message a
WHERE
a.START_TIME IN ( SELECT max( START_TIME ) FROM monitor_warn_message GROUP BY a.PROJECT_CODE )