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 vote362 views1 answer
C# get sql min date
SQL
0 vote333 views1 answer
Mysql terminal list table
SQL
1 vote350 views1 answer
Sql into vs insert into
SQL
0 vote349 views1 answer
Sql server datetime
SQL
1 vote348 views1 answer
Float precision in psql
SQL
1 vote345 views2 answers
Limit sqlserver
SQL
0 vote355 views1 answer
How to read the potentail error messages in ssis package
SQL
0 vote347 views1 answer
How to fetch unique records from two tables
SQL
8 votes363 views1 answer
Today minus 15 days postgresql
SQL
-2 votes337 views3 answers
Sqlite reset autoincrement
SQL