You can execute a DELETE statement to delete row data from a table. You can specify filter conditions.

Syntax

DELETE FROM table_name WHERE where_clause;

Examples

DELETE FROM dt WHERE p1 = 10 AND p2 = 20;
DELETE FROM dt WHERE p1 > 10;