Delete from t_book where t_id in (select id from (select max(t1.t_id) id from t_book t1 group by t1.t_name having count(1)>1) ab);Delete from t_book where t_id in (select id
Delete from t_book where t_id in (select id from (select max(t1.t_id) id from t_book t1 group by t1.t_name having count(1)>1) ab);Delete from t_book where t_id in (select id