4,707 questions
Hi @Jonathan Brotto ,
The MINUS keyword is from Oracle.
SQL Server equivalent is EXCEPT operator.
Check it out here: minus-vs-except-difference-in-oracle-sql-server
Does SQL server support minus keyword
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 6%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jonathan Brotto
1,076
Reputation points
Does SQL server 2019 support the minus keyword as we just updated our box and was in the process of rewriting some queries.
Developer technologies Transact-SQL
SQL Server Other
14,494 questions
Accepted answer
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky 26,586 Reputation points2022-02-15T19:56:42.127+00:00