Which SQL statement is used to delete data FROM a database?COLLAPSEREMOVEALTERDELETE

Answer

The SQL statement used to delete data from a database is DELETE.

The DELETE statement is employed to remove one or more rows from a table based on a condition specified in the WHERE clause. If a condition is not provided, all rows in the table will be deleted, which is generally not advisable without a backup.

For example, a basic syntax for the DELETE statement is:

DELETE FROM table_name WHERE condition;

In this example, table_name is the name of the table from which you want to delete data, and condition specifies which rows should be removed. If no condition is set, the command will remove all records from the specified table.