MINUS Keyword in SQL Server - Alternatives

added by SuprotimAgarwal
1/18/2011 5:12:00 AM

372 Views

MINUS operator (in oracle) is used to subtract the rows which are available in the second result, from the first result set. SQL Server does not have a built-in MINUS keyword, but in SQL Server, it’s equivalent is the EXCEPT operator or using NOT EXISTS


0 comments