SQL 查询运算符减号不起作用

发布于 2024-10-13 13:43:00 字数 516 浏览 9 评论 0原文

(SELECT IDOperatore FROM operatore) MINUS 
(SELECT IDOperatore FROM commessaoperatore GROUP BY IDOperatore)

即使我尝试将 MINUS 替换为 EXCEPT，此查询也不起作用。单一查询 SELECT IDOperatore FROM operatore 和 SELECT IDOperatore FROM commessaoperatore GROUP BY IDOperatore 正在工作，但如果我尝试将它们与 Minus 运算符放在一起不工作。

错误：#1064 - 您的 SQL 语法有错误；检查与您的 MySQL 服务器版本相对应的手册，了解在第 1 行“MINUS (SELECT IDOperatore FROM commessaoperatore GROUP BY IDOperatore)”附近使用的正确语法

原文

(SELECT IDOperatore FROM operatore) MINUS 
(SELECT IDOperatore FROM commessaoperatore GROUP BY IDOperatore)

This query is no working, even if I try to replace MINUS with EXCEPT.
The singular query SELECT IDOperatore FROM operatore and SELECT IDOperatore FROM commessaoperatore GROUP BY IDOperatore are working, but if I try to put together with Minus operator they don't work.

ERROR: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MINUS (SELECT IDOperatore FROM commessaoperatore GROUP BY IDOperatore)' at line 1

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

埋葬我深情 2024-10-20 13:43:00

mysql 中不存在 MINUS，

但是对于您的查询，您可以使用 NOT EXISTS：

SELECT IDOperatore FROM operatore o
WHERE NOT EXISTS (SELECT 1
                 FROM commessaoperatore c 
                 WHERE c.IDOperatore = o.IDOperatore)

MINUS does not exists in mysql

however for you query you can use NOT EXISTS:

SELECT IDOperatore FROM operatore o
WHERE NOT EXISTS (SELECT 1
                 FROM commessaoperatore c 
                 WHERE c.IDOperatore = o.IDOperatore)

回复收藏 0 原文

~没有更多了~