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

1 vote156 views2 answers
Replace text in sql
SQL
0 vote176 views1 answer
Difference between db.query and db.execute
SQL
0 vote173 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
2 votes185 views2 answers
Mysql write into table
SQL
3 votes167 views3 answers
Create table in microsoft sql server
SQL
2 votes207 views1 answer
Get the mysql table columns data type mysql
SQL
0 vote149 views1 answer
Sql server bool select
SQL
0 vote159 views1 answer
Restore backup mysql .gz
SQL
0 vote186 views1 answer
How to find top 3 salary in sql
SQL
0 vote151 views1 answer
Mysql date format unix timestamp
SQL