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

1 vote354 views1 answer
Sql string function update replace
SQL
4 votes331 views3 answers
Drop Table Oracle
SQL
2 votes344 views4 answers
Mysql get all tables row count
SQL
4 votes354 views1 answer
Oracle nls_date_format
SQL
1 vote328 views1 answer
Sql try catch
SQL
1 vote327 views2 answers
Mysql trim whitespace
SQL
0 vote339 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
0 vote329 views2 answers
Sql join on wildcard
SQL
1 vote332 views1 answer
Sql sort column by date
SQL
0 vote340 views1 answer
Alter column to not null with default value sql server
SQL