delete from test where id in ((select t.id from (select rownum rn,t.* from test t) t where rn >=200));
SQL删除特定ID记录
本文介绍了一条SQL语句用于从test表中删除ID大于等于200的记录。
delete from test where id in ((select t.id from (select rownum rn,t.* from test t) t where rn >=200));

被折叠的 条评论
为什么被折叠?