Share via

Does SQL server support minus keyword

Jonathan Brotto 1,076 Reputation points
Feb 15, 2022, 6:41 PM

Does SQL server 2019 support the minus keyword as we just updated our box and was in the process of rewriting some queries.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,697 questions
0 comments
Accepted answer
  1. Yitzhak Khabinsky 26,486 Reputation points
    Feb 15, 2022, 7:56 PM

    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

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.