Executing queries using DELETE statements

Executing queries using DELETE statements

The delete statement is used to delete certain records from the table based on a certain condition or expression.

Fig 7.10 shows how to execute the delete statement.

  • Fig 7.10

The fig 7.11 shows how this delete command is executed and the results are shown.

  • Fig 7.11

The above figure shows that the command is executed successfully and one particular row has been deleted from the table.