求这条sql该怎么写。 要求删除id为100-200 300-400 500-600...的数据 我写了一个有问题,麻烦大家帮我改下 begin for i in 1 .. 50 loop delete from test_append2 where id between i*100 and (i+1)*100; i:=i+1; end loop; commit; end;
------解决方案-------------------- between (2*i-1)*100 and 2*i*100 晕