摘要: delete A from Table A where exists(select count(*)c from Table B where A.col1=B.col1 and A.col2=B.col2 having count(*)>1) 注意 delete 后面的A必写,不然会报错 如果用in 阅读全文
posted @ 2016-03-30 11:22 xjt360 阅读(437) 评论(0) 推荐(0) 编辑