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

6 votes180 views2 answers
Oracle undotbs usage
SQL
0 vote169 views1 answer
Grant privileges of databse to user
SQL
3 votes236 views1 answer
Mysql group_concat distinct
SQL
3 votes165 views2 answers
Postgresql remove not null constraint
SQL
0 vote183 views1 answer
MySql Modify Increment
SQL
0 vote187 views1 answer
Select into table variable
SQL
3 votes245 views6 answers
Jwt laravel
SQL
2 votes179 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
0 vote192 views1 answer
Connecting mySQL to STS
SQL
1 vote172 views1 answer
Mamp mysql path mac
SQL