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 vote340 views1 answer
Mysql select and count left join
SQL
0 vote318 views1 answer
Trigger value from maltiple table to single table mysql
SQL
0 vote330 views1 answer
T-SQL Never ending DELETE
SQL
0 vote355 views2 answers
Mysql missin expression near on
SQL
0 vote313 views1 answer
Flask sqlalchemy decimal
SQL
0 vote322 views1 answer
Convert .mdf to .bak
SQL
2 votes313 views1 answer
Anonymous block plsql
SQL
49 votes375 views6 answers
Alter table add column
SQL
0 vote315 views1 answer
How to check default value of column in sql server
SQL
1 vote309 views1 answer
How to print longest name in sql
SQL