Use the DELETE statement to remove one or more rows. Deletion can be done in two variants:
- The DELETE FROM target: When the DELETE FROM target is used, data will be deleted from the table. To avoid situations like this, the WHERE condition needs to be filled in or you should add additions, such as ORDER BY, OFFSET, and UP TO.
- The DELETE target from the source: When we use the DELETE target from the source, we can only delete rows specific to a work area or multiple rows specified in a table.