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

11 votes601 views4 answers
Reset identity column values in sql server
SQL
0 vote212 views1 answer
Codeigniter dbforge add index
SQL
0 vote208 views1 answer
Sql server select top 2 of each group
SQL
1 vote212 views1 answer
Postgres get month name from date
SQL
0 vote239 views1 answer
Sql: extract day text from datetime value
SQL
0 vote223 views1 answer
Lesser than or equal to symbol in postgres
SQL
0 vote216 views2 answers
Get all index postgres
SQL
0 vote217 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
0 vote230 views1 answer
Mysql get only the field names in a table
SQL
5 votes237 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL