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

2 votes224 views1 answer
Sql ignore accents
SQL
2 votes236 views1 answer
Laravel sql String
SQL
0 vote250 views1 answer
Primary key multiple colums
SQL
0 vote233 views1 answer
How to output a different column name in mysql
SQL
0 vote240 views1 answer
How to execute stored output to csv files
SQL
0 vote234 views1 answer
Interview experience as a call?
SQL
1 vote239 views1 answer
Postgresql transaction discard all
SQL
0 vote229 views1 answer
Order by ip address sql
SQL
7 votes233 views4 answers
Database dump mysql command
SQL
0 vote241 views1 answer
Search column name sql
SQL