Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Posts
    4

    Unanswered: Minus query in DB2

    Two identical tables with the same table structure (10 columns) with different datasets, i need to find the minus ( A-B) , How can we write teh best query to get the output. Note : the number of records counts are above 50 lakhs.

    Appreciate for your help

    Thanks, suman
    Last edited by klenkala; 02-16-12 at 15:39.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    The standard SQL operator name for this is EXCEPT, I believe.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •