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
);