delete from
(
select rownumber() over(order by mchnt_cd,INS_CD ) AS rowid,t.*
from T_RECORD_INF t
where MCHNT_CD = '12306' and INS_CD = '08J05' and ROW_TP = '1' and ROW_ST = '1' )
WHERE
t.rowid>1
delete from
(
select rownumber() over(order by mchnt_cd,INS_CD ) AS rowid,t.*
from T_RECORD_INF t
where MCHNT_CD = '12306' and INS_CD = '08J05' and ROW_TP = '1' and ROW_ST = '1' )
WHERE
t.rowid>1