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

4 votes163 views2 answers
Installing sql on ubuntu
SQL
0 vote152 views1 answer
Mysql root permission denied lost
SQL
0 vote168 views1 answer
Space not removing from column in sql
SQL
0 vote151 views1 answer
Postgresql delete limit
SQL
0 vote159 views1 answer
Best sql collation
SQL
2 votes169 views3 answers
Sql server: how to concatenate column data using comma
SQL
3 votes157 views2 answers
Order by postgresql
SQL
0 vote151 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote155 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
54 votes350 views6 answers
Sql rename column
SQL