尝试以下简单查询-：

select code,max(deleted_date) MAX_DeletedDate
  from analyzes_test  
group by code 
  having count(deleted_date)>1

您可以在max date group by code上使用内部联接

select * 
FROM analyzes_test a
inner join  (
  select code, max(deleted_date) max_date 
  FROM analyzes_test 
  group by code  
)  t on t.max_date = a.deleted_date and t.code = a.code

或者如果您不希望代码的结果只有a可以使用的行

select * 
FROM analyzes_test a
inner join  (
  select code, max(deleted_date) max_date 
  FROM analyzes_test 
  group by code  
  having count(*)>1
)  t on t.max_date = a.deleted_date and t.code = a.code

试试这个： GROUP BY 以及 HAVING 将有助于检索每个代码的最大日期并将其用作 subquery 要检索表的所有信息，请执行以下操作：

SELECT ant.* 
FROM analyzes_test ant
INNER JOIN (SELECT code, MAX(deleted_date) max_date 
        FROM analyzes_test 
        WHERE deleted_date IS NOT NULL
        GROUP BY code
        HAVING COUNT(deleted_date) > 1) t ON t.code = ant.code 
    AND t.max_date = ant.deleted_date