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 vote187 views1 answer
Update foreign key value in mysql
SQL
-1 vote198 views1 answer
Pl sql drop trigger
SQL
3 votes228 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
4 votes190 views2 answers
Linq join
SQL
0 vote190 views1 answer
Sql server synonym
SQL
17 votes193 views6 answers
Change column name in sql
SQL
10 votes186 views5 answers
Mysql create user
SQL
2 votes203 views2 answers
Sqlalchemy return id after insert
SQL
1 vote185 views1 answer
Select dba users oracle
SQL
0 vote179 views1 answer
Postgresql show owner of database
SQL