SELECT * FROM temp a WHERE not exists
(SELECT 1 from kc b WHERE a.kcdm=b.kcdm and round(a.xf,1)=round(b.xf,1));
判断要导入课程是否存在
最新推荐文章于 2021-01-19 12:32:52 发布
SELECT * FROM temp a WHERE not exists
(SELECT 1 from kc b WHERE a.kcdm=b.kcdm and round(a.xf,1)=round(b.xf,1));