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 vote347 views1 answer
Insert query return id mysql
SQL
3 votes374 views1 answer
Mysql cli connect with password
SQL
0 vote291 views1 answer
10000000000000000000 am to meters
SQL
0 vote309 views1 answer
Mysql join only one column
SQL
0 vote303 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
1 vote317 views3 answers
How to filter repeated same result using sql query
SQL
16 votes315 views4 answers
Ascending order mysql
SQL
1 vote312 views1 answer
Md5 encryption for existing records
SQL
0 vote320 views1 answer
Mysql Install Ubuntu with native password
SQL
1 vote316 views1 answer
Mysql get domain from url
SQL