update (select * from pmegatest1 where c1=2 and c2='pmega' fetch first 1 rows only) set c1=11 with UR delete from (select * from pmegatest1 where c1=2 and c2='pmega' fetch first 1 rows only) with UR [출처] IBM DB2에서 select and update,delete 하기 (큰틀) |작성자 가이사 DELETE FROM (SELECT * FROM ${LIST_TABLE} WHERE POST_ID = '${POST_ID}' FETCH FIRST ${COMMIT_CNT} ROWS ONLY) WITH UR