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 vote260 views1 answer
Adding a check statement in sql
SQL
0 vote158 views1 answer
SQL Server format datetime
SQL
6 votes180 views2 answers
Postgresql pg_dump
SQL
0 vote169 views1 answer
Null column as zero in mysql
SQL
2 votes218 views3 answers
Row number mssql
SQL
0 vote216 views1 answer
Sql server sleep
SQL
6 votes185 views4 answers
Mysql group by month
SQL
1 vote171 views1 answer
Add many column to sap iq table
SQL
1 vote167 views1 answer
Postgres first_value in gropby
SQL
0 vote180 views1 answer
Postgres list all triggers
SQL