Chapter 24, Problem 17RE

Explanation of Solution

SQL query for deleting all customers in California:

Consider the following SQL statement that deletes all customers’ records in California State:

/* Delete the records permanently from the table */

DELETE FROM Customer

WHERE State = 'CA'

Explanation:

• The above “DELETE” query that removes all existing records permanently from the “Customer” table where the “State” is equal to “CA”.
  • “Customer” is the targeted table name to delete the certain number of rows that fulfills the specified condition...