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 vote131 views1 answer
Coalesce for comma separated in sql server
SQL
21 votes129 views1 answer
SQL cheat sheet pdf
SQL
2 votes175 views3 answers
3 days back in sql server
SQL
1 vote134 views1 answer
Mysql alter decimal precision
SQL
1 vote147 views1 answer
UseSqlServer no definition
SQL
0 vote129 views1 answer
Mysql update sum same table
SQL
0 vote128 views1 answer
Postgres week number
SQL
11 votes143 views2 answers
How to import mysql database command line
SQL
0 vote162 views1 answer
Alter database name script
SQL
1 vote131 views1 answer
Postgres check blocking
SQL