怎么删除前十条数据

剥夺者

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

woshenming

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

剥夺者

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

whbilly

举个例子：

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;

旋律de茶叶

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

panda_ren

旋律de茶叶正解

kiss01

用rownum

aeoluschen

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

不明白旋律de茶叶 后面的commit;是什么意思?哪位讲下!

whbilly

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