How to Delete in Redshift

To delete rows in a Redshift table, use the DELETE FROM statement:

DELETE FROM products WHERE product_id=1;

The WHERE clause is optional, but you'll usually want it, unless you really want to delete every row from the table.


SQL editing that just rocks

PopSQL and Redshift, better together