The DELETE statement is used to delete or remove all the rows from the table. Syntax:
DELETE FROM tableName;
Example:
DELETE FROM EMPLOYEE; |
Output:
3 row(s) deleted. |
The DELETE statement with where condition is used to delete or remove the specific rows from the table.
Syntax: DELETE FROM tableName [WHERE condition];
Example:
DELETE FROM EMPLOYEE WHERE EMP_ID = 5; |
output:
1 row(s) deleted. |
Next Topic: SQL TRUNCATE Table with example. Previous Topic: SQL DROP Table with example.
