Share via

Does SQL server support minus keyword

Jonathan Brotto 1,076 Reputation points
2022-02-15T18:41:42.877+00:00

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
Developer technologies | Transact-SQL

A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.

SQL Server | Other
0 comments No comments

Answer accepted by question author
  1. Yitzhak Khabinsky 27,106 Reputation points
    2022-02-15T19:56:42.127+00:00

    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 No comments

0 additional answers

Sort by: Most helpful

Your answer

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