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 vote343 views1 answer
Find most frequent value in SQL column
SQL
8 votes351 views1 answer
Oracle search source code
SQL
2 votes376 views1 answer
Cast string to datetime mysql
SQL
0 vote354 views1 answer
Mysql default timestamp value to be current timestamp
SQL
1 vote369 views1 answer
Avg mysql
SQL
0 vote355 views1 answer
Test sql query
SQL
0 vote361 views1 answer
List column names of multiple tables psql
SQL
2 votes426 views3 answers
Mysql unix timestamp to date
SQL
0 vote391 views1 answer
Psql check if sql script is valid
SQL
1 vote348 views1 answer
Sqlite create index
SQL