SELECT [字段] FROM A MINUS SELECT [字段] FROM B
你试下,哪个快点 SELECT [字段] FROM A EXCEPT SELECT [字段] FROM B -- SELECT A.[字段] FROM A LEFT JOIN B ON A.[字段]=B.[字段] WHERE B.[字段] IS NULL
SELECT [字段] FROM A EXCEPT SELECT [字段] FROM B -- SELECT A.[字段] FROM A LEFT JOIN B ON A.[字段]=B.[字段] WHERE B.[字段] IS NULL
34,591
社区成员
254,589
社区内容
加载中
试试用AI创作助手写篇文章吧