Delete a limited set of rows in a DB2 database - SQL Snipplr Social Repository

Revision: 60084

at October 22, 2012 21:47 by claudiodev

Updated Code

DELETE FROM <table> WHERE <column> IN ( 
	SELECT <column> FROM <table> WHERE <condition> FETCH FIRST <N> ROWS ONLY
)

Revision: 60083

at October 20, 2012 03:14 by claudiodev

Initial Code

DELETE FROM <table> WHERE <pkey> IN ( 
	SELECT <pkey> FROM <table> WHERE <condition> FETCH FIRST <N> ROWS ONLY
)

Initial URL

Initial Description

Delete a defined number of rows from a db2 database table

Initial Title

Delete a limited set of rows in a DB2 database

Initial Tags

sql

Initial Language

SQL