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 vote197 views1 answer
Sql create text column limited values
SQL
1 vote206 views1 answer
Check message id sql server
SQL
0 vote247 views1 answer
Select true if exists on another table or false sqlserver
SQL
0 vote211 views1 answer
Window function to forward fill
SQL
1 vote169 views1 answer
Unique vs distinct sql
SQL
0 vote200 views1 answer
Change permission to database mysql
SQL
0 vote297 views1 answer
Run mysql xampp shell
SQL
2 votes232 views1 answer
Import large .sql files into lampp
SQL
4 votes217 views1 answer
SQL find text in SP
SQL
3 votes300 views3 answers
Restart mysql mac
SQL