怎么删除前十条数据

[eversun820226]

我要做每删除10条记录提交一次,oracle里没有delete top 10 这个方法吗?

[liwater]

delete from table1
where id in (select top 10 id from table1...)...

[eversun820226]

delete from T3TN01_REGUL_STK_WORK where id in(select top 10 id from T3TN01_REGUL_STK_WORK where PROC_FLG = '1')这句话有什么错

[tgm78]

举个例子：

select r,e.* from (select rownum r,last_name,salary from (
select last_name,salary from employees order by nvl(salary,0) desc)) e
where r <11;

[snooper]

delete from table where rowid in (Select rowid from table where rownum <=10);
commit;

[wiler]

snooper(snooper)正解

[wy2000490]

用rownum

[kasoo]

delect from table where rownum<11;
这样好象也行.

不明白snooper(snooper) 后面的commit;是什么意思?哪位讲下!

[tgm78]

commit是提交事务，否则，dml的更新并没有写入数据库的数据文件，还在内存中