ようこそ (Jyokoso) MY BLOG

いらっしゃいませ (hajimemashite) สำหรับผู้เข้าใหม่นะค่ะ ^^V

21 มิถุนายน 2561

delete Dupplicate

 --------------------------------------delete Dupplicate---------------------------
 delete FCI_TBL_PC_I_14_PI_MOVEMENT
where ( rowid,transaction_id) in (select max(rowid),transaction_id
from FCI_TBL_PC_I_14_PI_MOVEMENT
where bus_place_code = '0002'
and transaction_date between  '20170801' and  '20170831'
and part_no ='4N15087'
group by transaction_id)
and  bus_place_code = '0002'
and transaction_date between  '20170801' and  '20170831'
and part_no ='4N15087'