How do I LIMIT the number of rows in a DELETE with DB2 ?

Question

Hi, I want to add a security on a sensitive table when I delete lines with an SQL request on a DB2 table.

I want to mimic the way MySQL allows you to limit the numbers of rows deleted in an SQL request.

Basically I want to do this with DB2 :

DELETE FROM table WHERE info = '1' LIMIT 1

Is there a way to do that with DB2 ?

Answer 1

delete from table where id in (select id from table where info = '1' order by id fetch first 1 rows only)

Answer 2

DELETE FROM table
WHERE info = '1'
FETCH FIRST 1 ROWS ONLY