Delete a limited set of rows in a DB2 database


/ Published in: SQL
Save to your folder(s)

Delete a defined number of rows from a db2 database table


Copy this code and paste it in your HTML
  1. DELETE FROM <table> WHERE <column> IN (
  2. SELECT <column> FROM <table> WHERE <condition> FETCH FIRST <N> ROWS ONLY
  3. )

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.