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 vote285 views1 answer
Sql query to find duplicate email address
SQL
8 votes237 views8 answers
Second highest salary in mysql
SQL
6 votes274 views1 answer
Phpmyadmin password root
SQL
0 vote308 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote269 views1 answer
Uuid sqlalcomany
SQL
0 vote266 views1 answer
Price-colour
SQL
0 vote262 views1 answer
Replace sqlalchemy
SQL
2 votes266 views1 answer
Oracle cpu per session
SQL
0 vote265 views1 answer
Minus equivalent in my sql
SQL
0 vote316 views1 answer
Virtuoso sql query tutorial
SQL