Search⌘ K
AI Features
Home
Courses
SQL Interview Preparation

Answer: Delete a Record

Explore how to delete specific records from a database table using the SQL DELETE statement and WHERE clause. Learn to safely remove data with practical examples, alternative methods, and variations to handle different scenarios.

We'll cover the following...

Solution

The solution is given below:

MySQL
/* The DELETE query to delete an existing record */
DELETE FROM Employees
WHERE       EmpID = 2;
/* Retrieve the records from the Employees table */
SELECT * FROM Employees;

Explanation

The explanation of the solution code is given below:

  • Line 2: The DELETE FROM statement is followed by the table name, Employees, which will be modified.

  • Line 3: The WHERE clause specifies the condition on which we want to delete the record. We’ll specify the employee ID 2 in this clause. ...