I am trying to do a following querey where I need to delete the records that have same 3 columns. However, I can not do the below query. Does anyone have any idea on how I can accomplish it .
delete from cargowise.shipmentdetails
where consolid,shipmentid,branch in (select distinct(consolid,shipmentid,branch) from cargowise.shipmentdetails_temp);