How to delete from a table having two filter clause with multiple combination.

Vote count:

0

delete from connect_customer_trans_bkp where (order_number,client_id) in (('0000220','ASD'),('0000221','acf'),('0000222','ddd'));

Instead of writing:

delete from connect_customer_trans_bkp where (order_number='0000220'and client_id='ASD') or 
 (order_number='0000221'and client_id='acf') or  (order_number='0000222'and client_id='ddd');

asked 52 secs ago

user3205300

1

How to delete from a table having two filter clause with multiple combination.