Answer: Delete a Record
Find a detailed explanation of how to delete a record from a table using an SQL query.
Solution
The solution is given below:
Press + to interact
/* The DELETE query to delete an existing record */DELETE FROM EmployeesWHERE 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 ID2
in this clause....
Level up your interview prep. Join Educative to access 70+ hands-on prep courses.