分组后最新的记录

LEFT JOIN (select patent_no,legal_flag from t_legal_status as b where not exists(select 1 from t_legal_status where patent_no= b.patent_no
and b.publication_date