oracleÖÐÈçºÎɾ³ý100ÌõÒÔºóµÄÊý¾Ý

ÈçÌ⣬ÎÒÏÖÔÚҪɾ³ýÇ°100ÌõÊý¾Ý£¬¿ÉÒÔÈçÏÂʵÏÖ

delete from tab_name where rownum < 101;
commit;

²»ÖªµÀÔõôɾ³ý100ÌõÒÔºóµÄÊý¾Ý£»

Çë¸÷λ´óϺָµãÒ»ÏÂÐֵܣ¡Ð»Ð»£¡

---

delete from tab_name where rownum > 100;

---

delete from tab_name where rownum < 101 order by id;
ÅÅÏÂÐò
»òÕßcreate table backup as delete from tab_name where rownum < 101

È»ºó±íÈ«²¿É¾³ý£¬ÔÙinsert »ØÈ¥
ÆÚ´ý¸üºÃµÄ·½·¨

---

delete from table
where rowid
(
select rowid from
(select rowid,rowunum rn from table order by rowid)
where rn <=100
)

---

ÒýÓÃ

delete from tab_name where rownum < 101 order by id;
ÅÅÏÂÐò
»òÕßcreate table backup as delete from tab_name where rownum < 101

È»ºó±íÈ«²¿É¾³ý£¬ÔÙinsert »ØÈ¥
ÆÚ´ý¸üºÃµÄ·½·¨

Õâ¸ö·½·¨¾ø¶Ô¿ÉÐУ¡ create table backup as select...

---

ÒýÓÃ

delete from table
where rowid
(
select rowid from
(select rowid,rowunum rn from table order by rowid)
where rn <=100
)

Õâ·½·¨²»´í

---

ÒýÓÃ

delete from table
where rowid
(
select rowid from
(select rowid,rowunum rn from table order by rowid)
where rn <=100
)