CodesJava

Easy learning with example program codes

SQL DELETE from table


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.

 

Please follow and like us:
Posted in SQL   


Copyright © 2019 CodesJava DMCA.com Protection Status SiteMap Reference: Java Wiki