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 vote116 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
3 votes155 views1 answer
What is having
SQL
0 vote165 views1 answer
Install postgresql 12 on debian 10
SQL
0 vote132 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
1 vote128 views1 answer
Mysql get domain from url
SQL
1 vote141 views2 answers
Oracle leftmost characters
SQL
0 vote129 views1 answer
Kill a pid redshift
SQL
0 vote128 views1 answer
SAP Return
SQL
0 vote135 views1 answer
Mysql update privileges
SQL
0 vote138 views1 answer
Hex string sql becomes int64
SQL