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 vote255 views1 answer
Create table with timestamp mysql youtube
SQL
-2 votes193 views1 answer
Group functions in sql
SQL
13 votes184 views2 answers
Sqlite rename column
SQL
0 vote182 views1 answer
How to export table data from mysql table in sql format
SQL
0 vote335 views1 answer
Sqlite display data in separated columns
SQL
1 vote194 views1 answer
Best configuration for display table in sqlplus
SQL
0 vote207 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
3 votes185 views1 answer
Postgres count distinct
SQL
0 vote181 views1 answer
C# mysql data reader from two tables
SQL
0 vote181 views1 answer
Data structures in sql
SQL