Computer Notes

Header Right

Home » Sql » Queries » SQL MINUS Operator

SQL MINUS Operator

By Dinesh Thakur

The MINUS query will compare each record in statement1 to a record in statement2. The result returned will be records in Select Statement1 that are not in Select statement2.

Syntax: [SQL Statement 1] MINUS [SQL Statement 2]
SELECT ENAME, EMPNO FROM EMP WHERE ENAME LIKE ‘M%,‘ OR ENAME LIKE ‘J%,‘;
MINUS
SELECT ENAME, EMPNO FROM EMP WHERE ENAME LIKE ‘J%‘ OR ENAME LIKE ‘A%‘;

On execution it will return those rows which exist in first statement only. It will not display common rows at all.

You’ll also like:

  1. C++ Program Illustrates The Overloading Of Unary Minus (-) Operator
  2. Write A C++ Program Illustrates The Overloading Of Unary Minus (-) Operator And Return Value.
  3. SQL LIKE Operator
  4. SQL IN Operator
  5. SQL BETWEEN Operator
Like/Subscribe us for latest updates     
About Dinesh Thakur
Dinesh ThakurDinesh Thakur holds an B.C.A, MCDBA, MCSD certifications. Dinesh authors the hugely popular Computer Notes blog. Where he writes how-to guides around Computer fundamental , computer software, Computer programming, and web apps.

Dinesh Thakur is a Freelance Writer who helps different clients from all over the globe. Dinesh has written over 500+ blogs, 30+ eBooks, and 10000+ Posts for all types of clients.


For any type of query or something that you think is missing, please feel free to Contact us.