The command to remove rows from a table ‘CUSTOMER’ is
A. DROP FROM CUSTOMER
B. UPDATE FROM CUSTOMER
C. REMOVE FROM CUSTOMER
D. DELETE FROM CUSTOMER WHERE..
Answer:A
The command to remove rows from a table ‘CUSTOMER’ is
A. DROP FROM CUSTOMER B. UPDATE FROM CUSTOMER C. REMOVE FROM CUSTOMER D. DELETE FROM CUSTOMER WHERE..
Explanation:The SQL DELETE Query is used to delete the existing records from a table. You can use WHERE clause with DELETE query to delete selected rows.