create table tmp as select min(TempOrderId) as col1 from temp_order_tbl where (UserName='' and IsRegisterUser='0' and ShoppingId=0) group by ProductTypeId;delete from temp_order_tbl where (UserName='' and IsRegisterUser='0' and ShoppingId=0) and TempOrderId not in (select col1 from tmp);drop table tmp;