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 vote101 views1 answer
Dump multiple tables mysql
SQL
32 votes121 views6 answers
How to change column name in sql
SQL
0 vote111 views1 answer
Mysql a from on this page has
SQL
4 votes123 views2 answers
What is table in sql
SQL
0 vote114 views2 answers
Getting customers with no orders sql
SQL
0 vote117 views1 answer
Example of sql querry result sepapreted by comma
SQL
2 votes105 views1 answer
Oracle kill job by sid
SQL
0 vote121 views1 answer
Safe mysql
SQL
0 vote128 views1 answer
Creating h2 database in relative directory eclopse
SQL
1 vote103 views1 answer
Oracle truncate partition
SQL