mysql根据条件删除重复的数据保留一条

delete from case_records where id not in (select id from (select min(id) as id from case_records where if_out=0 group by user_id) as b);