Which DELETE statement is valid?
A. DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
B. DELETE * FROM employees WHERE employee_id=(SELECT employee_id FROM new_employees);
C. DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = `Carrey’);
D. DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = `Carrey’);
Answer:C
Which DELETE statement is valid?
A. DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees); B. DELETE * FROM employees WHERE employee_id=(SELECT employee_id FROM new_employees); C. DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = `Carrey’); D. DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = `Carrey’);