做多行保存与更新的时候需要对属于某个主键的进行更新与插入需要用merge into
这是与mybatis结合使用的
MERGE INTO REAL_TAP_WATER_FIX HIS
USING (SELECT *
FROM (SELECT WATERSUPPLY,
WATERDEMAND,
COMPLAINTNUM,
WARNINGNUM,
REPAIRAREA,
PAUSESUPPLYAREA,
EVENTNUM,
STATDATE,
ROW_NUMBER() OVER(PARTITION BY STATDATE ORDER BY WATERSUPPLY) RN
FROM
<foreach
collection="list"
item="item"
index="index"
open="("
close=")"
separator="union all">
select
#{item.waterSupply} as waterSupply,
#{item.waterDemand