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 vote317 views1 answer
Install sql server in ubuntu 20.04
SQL
14 votes343 views2 answers
Oracle add attribute to table
SQL
0 vote324 views1 answer
Mysql c commands
SQL
0 vote317 views1 answer
Inserted row count tsql
SQL
0 vote295 views1 answer
Insert or update cassandra
SQL
1 vote354 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
5 votes342 views1 answer
Purge undo tablespace usage
SQL
19 votes317 views2 answers
Mysql tinyint max value
SQL
1 vote294 views3 answers
String to int mysql
SQL
1 vote320 views1 answer
Mysql workbench in ubuntu 14.04
SQL