Horje
compare subqueries oracle Code Example
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)));




Sql

Related
expose db in virtualbox Code Example expose db in virtualbox Code Example
view acl table oracle Code Example view acl table oracle Code Example
mysql CAST(amount as float) Code Example mysql CAST(amount as float) Code Example
c# sql conennection string Code Example c# sql conennection string Code Example
query to generate query to drop primary keys or foreign key in ms sql server Code Example query to generate query to drop primary keys or foreign key in ms sql server Code Example

Type:
Code Example
Category:
Coding
Sub Category:
Code Example
Uploaded by:
Admin
Views:
7