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 vote203 views1 answer
Mariadb select limit offset
SQL
2 votes218 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
0 vote293 views1 answer
Example database query
SQL
0 vote206 views1 answer
How to create a new shema using query languaage
SQL
17 votes261 views6 answers
MySQL ORDER BY
SQL
0 vote199 views1 answer
Postgresql copy backup table
SQL
0 vote205 views2 answers
Sql 2 way of select unique
SQL
0 vote212 views1 answer
How to select even id in sql
SQL
22 votes331 views4 answers
Mysql date format
SQL
3 votes196 views1 answer
Two select sql
SQL