--------------------------------------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'
ไม่มีความคิดเห็น:
แสดงความคิดเห็น