提个oracle数据库删除数据的新手有关问题
提个oracle数据库删除数据的新手问题
我要删除UserInfo表的第5行到第10行之间的数据
------解决方案--------------------
我要删除UserInfo表的第5行到第10行之间的数据
------解决方案--------------------
- SQL code
--默认排序的删除 delete UserInfo where exists (select 1 from (select rownum rn,UserInfo.主键列 from UserInfo) t where t.主键列=UserInfo.主键列 and t.rn between 5 and 10);
------解决方案--------------------
delete UserInfo
where exists (select 1 from (select rownum rn,UserInfo.主键列 from UserInfo) t
where t.主键列=UserInfo.主键列 and t.rn between 5 and 10);
------解决方案--------------------
这个是正解啊
------解决方案--------------------
delete from UserInfo where rownum between 5 and 10;
你试一下,看对不?
------解决方案--------------------