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 vote201 views1 answer
Bitmap join index
SQL
0 vote193 views1 answer
Mysql create pool
SQL
0 vote263 views1 answer
Sql alter table add column if exists
SQL
0 vote187 views2 answers
Sql day from datetime
SQL
0 vote198 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
0 vote181 views1 answer
Get records in sql according to month name and count
SQL
0 vote204 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
6 votes212 views2 answers
Join vs union
SQL
3 votes225 views2 answers
Sqlite show table definition
SQL
0 vote226 views1 answer
Find wordpress version in database
SQL