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

-2 votes295 views1 answer
How-to-remove-mysql-root-password
SQL
0 vote262 views1 answer
Initcap in sql
SQL
0 vote271 views1 answer
Sql add calculated column
SQL
18 votes269 views3 answers
Mysql add column with default value
SQL
1 vote282 views1 answer
Round function in sql oracle
SQL
15 votes289 views6 answers
Laravel db transaction
SQL
0 vote297 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
0 vote260 views1 answer
Replace null value within column mysql
SQL
1 vote282 views1 answer
Create another table from existing table sql oracle
SQL
0 vote277 views1 answer
Postgres type equivalent to timespan c#
SQL