To remove only the records where the status = 'Inactive' from a table named…
2026
To remove only the records where the status = 'Inactive' from a table named Accounts, which query is correct?
Answer: A. DELETE FROM Accounts WHERE status = 'Inactive';
- A.
DELETE FROM Accounts WHERE status = 'Inactive';
- B.
DROP FROM Accounts WHERE status = 'Inactive';
- C.
REMOVE FROM Accounts WHERE status = 'Inactive';
- D.
TRUNCATE Accounts WHERE status = 'Inactive';
Attempted by 840 students.
Show answer & explanation
Correct answer: A
Loading lesson…