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 vote320 views1 answer
Get clob size oracle
SQL
18 votes302 views6 answers
Creating table in MySQL
SQL
2 votes306 views1 answer
Mysql sysdate - 1 day
SQL
14 votes323 views3 answers
How to add default constraint in mysql
SQL
0 vote307 views1 answer
Insert or update sql firebird
SQL
2 votes282 views1 answer
Select * from table where name like
SQL
0 vote287 views1 answer
Month mysql
SQL
0 vote336 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote282 views1 answer
Sql cross apply vs join
SQL
0 vote299 views2 answers
Select columns from 2 tables with foreign key
SQL