DELETE Examples | SQL Statements | Teradata Vantage - Example: DELETE Set of Rows - Advanced SQL Engine - Teradata Database

This example deletes all rows with a department number of 500 from the employee table:

     DELETE FROM employee
     WHERE deptno=500;