# 需要先创建唯一索引或者唯一主键
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
posted on
2022-08-22 15:46没有陌生人
阅读(4)
评论(0)
编辑收藏举报