【求助】db2 update 一张表的前100行的某个字段，sql该怎么写？？
------解决方案--------------------------------------------------------
UPDATE ADDRESS SET REMARK='abc' WHERE ADD_ID IN (
SELECT a.ADD_ID FROM
(
select rownumber() over(order by ADD_ID) rownum,c.ADD_ID FROM ADDRESS c
) a where a.rownum <= 5
);
------解决方案--------------------------------------------------------
前100行的某个字段：什么标准
UPDATE tt a
SET a.f1=' '
WHERE a.row_id in
(
SELECT b.row_id FROM tt b fetch first 100 rows only
) rr
or
UPDATE (SELECT * FROM tt FETCH FIRST 100 ROWS ONLY) AS U SET f1='';