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 votes323 views1 answer
Oracle Column Names of a table
SQL
0 vote283 views1 answer
Postgresql print variable
SQL
2 votes310 views1 answer
Dbms transaction (psql)
SQL
0 vote299 views1 answer
Oracle table free space
SQL
4 votes324 views1 answer
Mysql delete last row
SQL
2 votes311 views1 answer
Sqlplus clear screen
SQL
0 vote651 views1 answer
Sql field equals multiple values
SQL
0 vote298 views1 answer
Query by column for substring sql
SQL
1 vote282 views1 answer
Sql sort column by date
SQL
22 votes272 views6 answers
Create sql table
SQL