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 vote122 views1 answer
Sql reverse order of results
SQL
0 vote115 views1 answer
Mysql create table like
SQL
0 vote184 views3 answers
Insert or ignore postgres
SQL
4 votes144 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
0 vote115 views1 answer
How to reset table in sql server
SQL
0 vote132 views1 answer
How to create a new db from dumb file mysql
SQL
1 vote117 views1 answer
ORA-01950
SQL
11 votes299 views4 answers
Round in sql
SQL
0 vote116 views1 answer
Duplicate value unique constraint mysql error
SQL
0 vote129 views1 answer
Add sqlcmd to path linux
SQL