SQL Delete Command

SQL Delete Command

Delete command is used to delete the record from the table.

• Using Delete command you can delete all the records from the table without delete table.
• Using Delete command you can delete specific records from the table "using where clause"

	
DELETE FROM table_name
WHERE some_column=some_value;

Employee table

DELETE FROM Employee
WHERE salary<30000;

Result after Execute above query.

Difference between truncate and delete

Delete all record

You can also delete all the record from a table without deleting table.

	
DELETE FROM table_name
or
DELETE * FROM table_name;

DELETE FROM Employee