----这样些,更新语句不能你那样些排序 Update ADD_SAMPLEMANAGER set ISSHOW is null where rowid in (select rowid from (select rownum rn, rowid from ADD_SAMPLEMANAGER t order by t.ORIGREC desc) where rn <= 100)
set ISSHOW = null
Update ADD_SAMPLEMANAGER set ISSHOW = null where rowid in (select rowid from ADD_SAMPLEMANAGER where rownum<100)
Update ADD_SAMPLEMANAGER set ISSHOW = null where rowid in (select rid from (select a.*,rowid rid from ADD_SAMPLEMANAGER a order by ORIGREC desc) where ROWNUM <= 100 )
----这样些,更新语句不能你那样些排序
Update ADD_SAMPLEMANAGER
set ISSHOW is null
where rowid in (select rowid
from (select rownum rn, rowid
from ADD_SAMPLEMANAGER t
order by t.ORIGREC desc)
where rn <= 100)
Update ADD_SAMPLEMANAGER
set ISSHOW = null
where rowid in (select rowid
from ADD_SAMPLEMANAGER
where rownum<100)
set ISSHOW = null
where rowid in (select rid
from (select a.*,rowid rid from ADD_SAMPLEMANAGER a order by ORIGREC desc) where ROWNUM <= 100 )