create table tmp001 as select min(jid) as col1 from xiweb_xxx group by tname;
delete from xiweb_xxx where jid not in (select col1 from tmp001);
drop table tmp001;

min()为保留最小jid的记录

点赞 (0)