SELECT * WHERE A.id = B.id AND A.daytime >= C.daytimeAND (C.end_date IS NULL OR A.daytime < C.end_date) AND A.daytime = D.daytime(+) AND A.daytime = E.
用以前的值更新列,其中列为null:SET a.ch_size = SELECT LAG(ch_size) OVER (ORDER BY item, daytime) as prev_choke WHERE a.item = b.item AND a.daytime=b.daytimeWHERE a.ch_sizeIS NULL AND a.sub_hours = 0.5
但由于某些原因,它设置为null,而有之前的值,请参见下面的示