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

3 votes202 views3 answers
List columns in table postgres
SQL
3 votes228 views6 answers
Jwt laravel
SQL
10 votes205 views2 answers
Forgot my mysql password mac
SQL
0 vote219 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
1 vote212 views1 answer
Sql select all from one table and one column from another
SQL
0 vote213 views2 answers
Sql max count
SQL
7 votes206 views3 answers
Convert ansi sql
SQL
2 votes214 views1 answer
Compare date in sql
SQL
0 vote233 views1 answer
SQL-Arten
SQL
0 vote254 views1 answer
Sp help text in postgresql
SQL