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 vote383 views1 answer
Get last three characters in mysql column
SQL
0 vote371 views1 answer
Sql on-premises
SQL
27 votes432 views3 answers
Mysql delete row
SQL
5 votes368 views3 answers
Sql max value in column
SQL
0 vote390 views1 answer
Postgres get database encoding
SQL
-1 vote355 views1 answer
Sql set max value in column
SQL
2 votes374 views1 answer
Db.relationship sqlalchemy flask
SQL
0 vote357 views1 answer
Mysql cdn link
SQL
0 vote364 views2 answers
Get top 1 row of each group
SQL
2 votes343 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL