You can't specify target table 'c_fqc_group_mapping_t' for update in FROM clause

zhgc

You can't specify target table 'c_fqc_group_mapping_t' for update in FROM clause





delete from sfc.c_fqc_group_mapping_t
where ( model_name,almtype,group_name,idd) not in (
select  model_name,almtype,group_name,min(idd) from  sfc.c_fqc_group_mapping_t
group by model_name,almtype,group_name)



改为

delete from sfc.c_fqc_group_mapping_t
where ( model_name,almtype,group_name,idd) not in
(select * from
        (
        select  model_name,almtype,group_name,min(idd) from  sfc.c_fqc_group_mapping_t
        group by model_name,almtype,group_name
        ) aa
)


select的结果再通过一个中间表select多一次，就可以避免这个错误