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 vote232 views1 answer
How to define a non primary composite key in sql
SQL
0 vote191 views3 answers
Mysql keyword search
SQL
0 vote203 views1 answer
How to query without duplicate rows in sql
SQL
1 vote199 views1 answer
Oracle list data files
SQL
7 votes202 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
0 vote194 views1 answer
Oracle temporary table
SQL
8 votes185 views3 answers
Alter table auto_increment
SQL
2 votes249 views1 answer
How to check if a row is null in sql
SQL
2 votes187 views1 answer
Tsql copy table
SQL
0 vote205 views1 answer
Mysql récupérer le code création de vue
SQL