数据量小，直接删除就行

delete table_1 where rowid <(select max(rowid) from table_1);

数据量大，删除耗时过长，可以考虑新建表后改名使用

create table table_2 as select * from table_1  where  rowid =(select max(rowid) from table_1) ;
ALTER TABLE table_1 RENAME TO table_1_old;
ALTER TABLE table_2 RENAME TO table_1;

数据操作前核对是否正确