Oracle Minus | Sql Minus - oracle tutorial - sql tutorial



Oracle minus

Learn oracle - oracle tutorial - Oracle minus - oracle examples - oracle programs

What is Oracle MINUS ?

  • MINUS operator is used to return all rows in the first SELECT statement that are not returned by the second SELECT statement.
  • Each SELECT statement has a dataset and the MINUS operator returns all documents from the first dataset and then removes all documents from the second dataset.

Syntax:

SELECT column_name
FROM table1_name
MINUS
Select column_name
FROM table2_name
click below button to copy the code. By - oracle tutorial - team

Example:

SELECT name
FROM wikitechy_employee
MINUS
Select name 
FROM wikitechy_employee1;
click below button to copy the code. By - oracle tutorial - team

Code Explanation:

Before Execution:

  • Table1 is shown
  • Table2 is shown
oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql

AFTER EXECUTION:

  1. Using the “MINUS statement“ The given query returns only rows returned by the first query but not by the second.

Oracle Union - Oracle UnionAll - Oracle Except - Oracle Intersect

Union UnionAll Except Intersect

This tutorial provides an in depth knowledge on the following items such as oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , mysql tutorial , learn sql , oracle database tutorial , sql query tutorial , oracle dba tutorial , plsql tutorial , oracle tutorial pdf , oracle pl sql tutorial , oracle sql tutorial , sql tutorial point , oracle tutorial for beginners , learn oracle online free , learn oracle online , learning pl sql programming , learn sql online for free , sql learning online , dba oracle tutorial , oracle sql tutorial advanced , oracle 11g dba tutorial with examples , oracle online learning , oracle learning online , how to learn pl sql , sql coding tutorial , sql learning websites , sql basic learning

Related Searches to oracle Minus | Sql Minus