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 vote326 views1 answer
Porcentaje sql
SQL
1 vote333 views1 answer
Create sqlite database in laravel
SQL
1 vote351 views1 answer
Age postgres
SQL
7 votes334 views6 answers
Group_concat mysql
SQL
0 vote341 views1 answer
How to move a column to different spot mysql
SQL
0 vote355 views1 answer
Oracle activate program
SQL
0 vote332 views1 answer
How to combine rows in sql server procedure
SQL
8 votes312 views2 answers
Alter column name in mssql
SQL
3 votes346 views2 answers
Enter mysql command line
SQL
0 vote324 views1 answer
Sqlalchemy.exc.OperationalError:
SQL