Question

informix中怎样用sql语句删除前n条记录

Answer 1

由于informix的first选项限制较多，不能用在子查询，也不能用在into temp的select语句中，感觉一个sql写不出来。
用下面的select语句生成一堆delete语句，然后再跑这些delete语句：
select first 100 'delete from TableName where rowid='|| rowid ||';' from TableName order by begintime;

Answer 2

delete from test
where rowid in
(select * from (select first 100 rowid from test where mod(rowid,2)= 1));