Question

Write an SQL statement to delete all records with a reason of 'rejected'. How many records were deleted?

Answer 1

To delete records with a reason of 'rejected', use the SQL DELETE statement targeting the appropriate table. SQL does not inherently provide the count of deleted records, but most SQL environments report the number of affected rows after statement execution.

Step-by-step explanation:

To delete all records with a 'rejected' reason from a database, you would use the SQL DELETE statement. This statement looks as follows:

DELETE FROM table_name
WHERE reason = 'rejected';

Replace table_name with the actual name of the table from which you want to remove the records. Unfortunately, SQL itself does not tell you the number of records deleted as part of a DELETE statement.

However, most SQL environments, such as MySQL or PostgreSQL, report the number of affected rows after the execution of a statement. To get the exact count of records deleted, you would need to use a specific feature or function provided by your SQL environment.