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

1 vote178 views1 answer
How to update date add hours in postgresql
SQL
17 votes180 views4 answers
Show tables sql server
SQL
0 vote179 views1 answer
Teller stamp , bmo , PDF
SQL
0 vote202 views2 answers
How to check if sqlite table exists in nodejs
SQL
0 vote186 views1 answer
Sql last 7 days
SQL
0 vote173 views1 answer
Oracle list chain steps
SQL
1 vote190 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
1 vote185 views1 answer
Simple project for database
SQL
24 votes224 views4 answers
Delete db postgres
SQL
0 vote137 views1 answer
Mysql convert column to uppercase
SQL