这里用的是子查询 select * from TQ_DIAGNOSTIC_TASK t where t.id in (select max(s.id) from TQ_DIAGNOSTIC_TASK s where s.DIAGNOSTIC_ID = t.DIAGNOSTIC_ID); GROUP BY select DIAGNOSTIC_ID from TQ_DIAGNOSTIC_TASK GROUP BY DIAGNOSTIC_ID DISTINCT select DISTINCT DIAGNOSTIC_ID from TQ_DIAGNOSTIC_TASK