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 vote256 views1 answer
Sql current timestamp
SQL
15 votes256 views6 answers
Psql
SQL
1 vote267 views1 answer
Mysql how to truncate table with foreign keys
SQL
1 vote275 views2 answers
Procedure syntax
SQL
10 votes211 views1 answer
Oracle view dependencies
SQL
0 vote248 views2 answers
How to type a blank discord messgae
SQL
1 vote262 views1 answer
Mysql current running queries
SQL
0 vote280 views1 answer
Replace divide by zero error with 0 in sql
SQL
9 votes271 views4 answers
Mysql set id auto increment
SQL
0 vote242 views1 answer
Mysql begin statement
SQL