表中有10条记录， delete删除前5条，该怎么做？

[zxcdewq]

表中有10条记录， delete删除前5条，该怎么做？

[bzszp]

不排序，根据物理地址大小
try:
delete from tbname where rownum<6;

[tgm78]

SQL> select * from test000;

USERID
----------
1
2
2
3
4
5
6
7
8
9

10 rows selected

SQL> delete from test000 where rownum<6;

5 rows deleted

SQL> commit;

Commit complete

SQL> select * from test000;

USERID
----------
5
6
7
8
9

SQL>

[wow1war2cs3]

做好排序后
SQL> delete from ***（你的表） where rownum<6;