SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ï棡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд

---

Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

---

21-30ÊÇʲôÒâ˼£¿×ֶεĻ°¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µÄÊǵڼ¸Ìõ¼Ç¼µÄ»°
delete from table1 where rowid in 
  (select rd from (
  select rowid rd,rownum rn from table1)
  where rn>=21 and rn<=30)

---

ѧϰ¡£¡£¡£

---

delete from table1 where rn in 
  (
  select rn 
  from 
  ( 
  select row_number() over(partition by ??(ÄãÒªÅÅÐòµÄ×Ö¶Î) rn order by rowid 
  from table1
  ) 
  where rn>=21 and rn <=30
  )

---

up