SQL Delete

SQL DELETE keyword is used to delete the records from the table. Here is the general form to use DELETE keyword in SQL to delete the rows present in the table:

DELETE FROM table_name
WHERE some_column=some_value;

Here SQL Where clause is used to specify which record(s) is going to delete.

SQL DELETE Keyword Example

Here is an example of SQL DELETE keyword. Let's suppose, we have the following table named CUSTOMERS in the database:

sql delete

Following is an example, which would DELETE a customer, whose ID is 3.


After querying the above SQL statement, it will delete the customer having id as 3.

Now the new table will be:

sql delete keyword

SQL Online Test

« Previous Tutorial Next Tutorial »

Like/Share Us on Facebook 😋