select C1,C2 from (select rownum rw, C1,C2 from TABLE_NAME order by C1 desc ) where rw>100 ; 删除 delete from TABLE_NAME where C1 in (select C1 from (select rownum rw, C1,C2 from TABLE_NAME order by C1 desc ) where rw>100 and C2>1);
第2个回答 2016-07-07
select * from (select * from TABLE_NAME order by c1 asc) where rownum <= 100追问
取100行以后的数据,不是前100行。 并且取了之后,再删除其中C2大于1的行。
追答
select * from (select * from TABLE_NAME order by c1 asc) where rownum > 100 TABLE_NAME中主键值或唯一索引值吗?