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

3 votes240 views1 answer
Locate sql server
SQL
0 vote213 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote238 views4 answers
First max salary in sql
SQL
0 vote222 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
1 vote246 views1 answer
Ora-01109 database not open in oracle 19c
SQL
0 vote233 views1 answer
Exit psql
SQL
2 votes213 views1 answer
Postgresql format date dd/mm/yyyy
SQL
11 votes241 views5 answers
Update table from another table mysql
SQL
0 vote230 views1 answer
Sql server select value large text
SQL
19 votes240 views6 answers
Sql drop table if exists
SQL