DELETE FROM table_name [ WHERE condition ]
Delete rows from a table. If the
WHERE clause is specified, only the
matching rows are deleted. Otherwise, all rows from the table are deleted.
Delete all line items shipped by air:
DELETE FROM lineitem WHERE shipmode = 'AIR';
Delete all line items for low priority orders:
DELETE FROM lineitem WHERE orderkey IN (SELECT orderkey FROM orders WHERE priority = 'LOW');
Delete all orders:
DELETE FROM orders;
Some connectors have limited or no support for
See connector documentation for more details.