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 vote286 views1 answer
Sql multiple into
SQL
0 vote254 views1 answer
Concatenate columns in table
SQL
0 vote285 views1 answer
Add created and updatedAt fields in mysql
SQL
0 vote248 views1 answer
Create domain sql
SQL
0 vote259 views1 answer
Inser into example
SQL
0 vote269 views1 answer
Mysql error 1452
SQL
1 vote278 views1 answer
Oracle enable job
SQL
1 vote263 views3 answers
Sql server get week dates from week number
SQL
25 votes302 views4 answers
Import mysql dump command line
SQL
0 vote302 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL