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 vote111 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
3 votes114 views1 answer
Sql several or
SQL
2 votes119 views1 answer
Oracle run_duration average
SQL
10 votes119 views1 answer
Oracle view dependencies
SQL
0 vote106 views1 answer
Phpmyadmin mysql conflict
SQL
0 vote116 views4 answers
Forenkey code alchemy sql
SQL
1 vote118 views1 answer
Sql count value greater than
SQL
1 vote129 views1 answer
Mysql breakline on string
SQL
1 vote121 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
0 vote119 views2 answers
Pop sql insert value into
SQL