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

3 votes104 views1 answer
Sql datetime as date
SQL
12 votes106 views6 answers
Select distinct
SQL
2 votes117 views1 answer
Mysql select true or false
SQL
4 votes228 views2 answers
Sql display today's date
SQL
-1 vote90 views2 answers
On update cascade
SQL
0 vote97 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
2 votes102 views1 answer
Columns Present in a table
SQL
0 vote102 views1 answer
How to check default value of column in sql server
SQL
3 votes90 views2 answers
Mysql add 2 hours
SQL
1 vote135 views1 answer
Hangfire clear all jobs
SQL