SQL语句问题，高手帮忙！！

将一个表21~30删除，sql语句怎么写

---

这个太笼统了，是排序后的第21条到30条记录删除还是某一列值在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