Which SQL statement deletes rows from a table? (Is a clause)

Which SQL statement deletes rows from a table? (Is a clause)

• A. Delete From
• B. From
• C. Add
• D. Select

Answer: (A)

Deleting rows in a table is done with the DELETE statement. The common form is DELETE FROM table_name WHERE condition, where FROM specifies which table to target and the WHERE clause defines which rows to remove (omitting WHERE deletes all rows). The other options aren’t used for removing data: From by itself isn’t a complete statement, Add isn’t an SQL command for modifying data, and Select is used to fetch data, not delete it. So the correct approach is the DELETE statement with FROM to specify the table.

Deleting rows in a table is done with the DELETE statement. The common form is DELETE FROM table_name WHERE condition, where FROM specifies which table to target and the WHERE clause defines which rows to remove (omitting WHERE deletes all rows). The other options aren’t used for removing data: From by itself isn’t a complete statement, Add isn’t an SQL command for modifying data, and Select is used to fetch data, not delete it. So the correct approach is the DELETE statement with FROM to specify the table.