Deviopath › PostgreSQL

Remove Cancelled Orders

Easy · Delete

DELETE FROM table WHERE condition; removes the rows that match. Like UPDATE, it affects every row if you forget WHERE.

Delete every order whose status is 'cancelled'. The checker then lists the remaining orders.

Next: Create a Reviews Table