# 需要先创建唯一索引或者唯一主键 replace into labels.label_last_new(StockId,StockName,LabelName,EnabledStatus,OccurrenceDate) select StockId,StockName,LabelName,EnabledStatus,max(OccurrenceDate) from labels.t_stocklabel2022 as t2 group by StockId