我有一张表,我想更新20-30的数据,我的语句如下:update 表名
set 字段='成都'
where rownum in
(SELECT ROWNUM RN
FROM (SELECT * FROM 表名 where 字段='四川')
)
and rownum BETWEEN 10 AND 20结果发现只能更新一条,请问这应该怎么写啊!
set 字段='成都'
where rownum in
(SELECT ROWNUM RN
FROM (SELECT * FROM 表名 where 字段='四川')
)
and rownum BETWEEN 10 AND 20结果发现只能更新一条,请问这应该怎么写啊!
SELECT ROWNUM RN
FROM (select * from emp where deptno='20')这个查出来是多少行啊
update 表名
set 字段='成都'
where rowid in
(SELECT rowid
FROM (SELECT ROWNUM,表名.* FROM 表名 where 字段='四川')
WHERE rownum BETWEEN 10 AND 20
)
SELECT ROWNUM RN
FROM (SELECT * FROM 表名 where 字段='四川')
我这个查询出来有30多条
set 字段='成都'
where rownum in
(SELECT ROWNUM RN
FROM (SELECT * FROM 表名 where 字段='四川') where RN<11
)
============
想一次性更新11条
set 字段='成都'
where 字段名 in
(SELECT 字段名
FROM (SELECT 字段名 FROM 表名 where 字段='四川') where rownum<11
)
update 表名
set 字段='成都'
where 字段名 in
(SELECT 字段名 FROM 表名 where 字段='四川' and rownum<11)