本文提供了一个使用SQL语句批量更新数据库中特定记录的示例。通过两个UPDATE语句展示了如何将表mytable中的node_index字段设置为0，分别针对procs_dt非空和procs_dt为空的情况，并对每种情况都进行了限制，只更新前10条记录。
UPDATE mytable
SET node_index = 0
WHERE rowid IN
(
SELECT rid
FROM (
SELECT rowid AS rid
FROM mytable
WHERE procs_dt IS NOT NULL
ORDER BY
cret_dt, prty
)
WHERE rownum <= 10
)
update mytable set node_index=0 where id in (
SELECT
id
FROM
( SELECT id FROM mytable WHERE procs_dt IS NULL order by CRET_DT,PRTY desc)
WHERE
rownum<=10
)
SET node_index = 0
WHERE rowid IN
(
SELECT rid
FROM (
SELECT rowid AS rid
FROM mytable
WHERE procs_dt IS NOT NULL
ORDER BY
cret_dt, prty
)
WHERE rownum <= 10
)
update mytable set node_index=0 where id in (
SELECT
id
FROM
( SELECT id FROM mytable WHERE procs_dt IS NULL order by CRET_DT,PRTY desc)
WHERE
rownum<=10
)
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
