Compare subqueries oracle

// use NOT EXISTD (A MINUS B) instead of =

SELECT DISTINCT H1.HE_ID, H2.HE_ID
  FROM INV_HEAD H1, INV_HEAD H2
  WHERE H1.ID <> H2.ID
  AND NOT EXISTS(
    ((SELECT ART_ID, QUANTITY, PRICE FROM INV_POS WHERE HE_ID = H1.ID) 
      MINUS 
     (SELECT ART_ID, QUANTITY, PRICE FROM INV_POS WHERE HE_ID = H2.ID)) 
      UNION 
    ((SELECT ART_ID, QUANTITY, PRICE FROM INV_POS WHERE HE_ID = H2.ID) 
     MINUS 
     (SELECT ART_ID, QUANTITY, PRICE FROM INV_POS WHERE HE_ID = H1.ID)));

Source: stackoverflow.com

Similar codes

0 vote102 views1 answer
How to connect postgresql database with java
SQL
4 votes98 views3 answers
Sql drop database if exists
SQL
0 vote110 views1 answer
Download sql file of countries names
SQL
2 votes100 views2 answers
Get all tables using like
SQL
0 vote221 views1 answer
The differnece between to values in sql
SQL
0 vote102 views1 answer
Mariadb number format
SQL
0 vote112 views1 answer
Oracle flush Shared Pool
SQL
1 vote105 views2 answers
Mysql SELECT
SQL
0 vote92 views1 answer
Date diff sql
SQL
23 votes100 views6 answers
Delete all rows from table sql
SQL