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 vote156 views1 answer
Mysql events not work
SQL
5 votes169 views2 answers
Mysql date greater than 30 days
SQL
0 vote186 views2 answers
Call to undefined function mysql_query()
SQL
2 votes175 views1 answer
Postgresql drop primary key constraint
SQL
21 votes175 views1 answer
Cheatsheet for sql
SQL
1 vote160 views1 answer
Mysql show data from table
SQL
0 vote173 views1 answer
Max mysql
SQL
6 votes161 views2 answers
WHERE value IS sql
SQL
0 vote200 views1 answer
Install mysql on bash
SQL
3 votes185 views2 answers
Update Query in SQL Server
SQL