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 vote194 views1 answer
Select into table variable
SQL
1 vote269 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
1 vote189 views1 answer
Oracle enable job
SQL
0 vote188 views1 answer
Unique index in mysql
SQL
0 vote168 views1 answer
Oracle list index on table
SQL
1 vote203 views1 answer
How to delay stored procedure execution in sql server
SQL
4 votes171 views3 answers
Oracle sql first day of quarter
SQL
24 votes188 views4 answers
Mssql get all table names
SQL
0 vote173 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote277 views1 answer
Sql if clause within where clause
SQL