Delete Statement Examples

Example 1

Delete From customers c
Where c.insolvency = 'YES' ;

Example 2

Delete From send_sms s
Where s.id_invoice IN (Select i.invoice_id
                                          From invoices i
                                        Where i.amount <= 1
                                            And i.invoice_id = s.invoice_id
                                         );