sql - how to delete every row not containing a list of values -
i'm trying delete remaining row in table doesn't exist in list program i'm making generates. 1 of ways have tried. each way change continue 'invalid relational operator' error
delete bb_pub.epub_agent_trnprt '39800013','39800022','39800009','39800023','39800011','39900001','39800025','39800016','39800014','39600003' not in (transport_id);
try this
delete bb_pub.epub_agent_trnprt transport_id not in ('39800013','39800022','39800009','39800023', '39800011','39900001','39800025','39800016','39800014','39600003');
Comments
Post a Comment