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

19 votes151 views6 answers
Sql drop table if exists
SQL
0 vote160 views1 answer
Sql values not in another table
SQL
4 votes151 views2 answers
Oracle set date format
SQL
0 vote144 views1 answer
Groupby error in mysql
SQL
0 vote137 views1 answer
Selecting Data in SQL - Select Data
SQL
9 votes142 views2 answers
Default number in sql
SQL
3 votes150 views1 answer
Oracle list privileges
SQL
0 vote154 views2 answers
Identity column in sql server
SQL
0 vote151 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
1 vote142 views1 answer
How to delete a record from sqlite in android
SQL