SQL SERVER – EXCEPT Clause in SQL Server is Similar to MINUS Clause in Oracle

 SQL SERVER – EXCEPT Clause in SQL Server is Similar to MINUS Clause in Oracle

Query in SQL Server:

SELECT EmpNo, EmpName
FROM Emp WHERE Salery > 1000
EXCEPT
SELECT EmpNo, EmpName
FROM Emp WHERE Salery > 2000
ORDER BY EmpName;

 Query in Oracle:

SELECT EmpNo, EmpName
FROM Emp WHERE Salery > 1000
MINUS
SELECT EmpNo, EmpName
FROM Emp WHERE Salery > 2000
ORDER BY EmpName;