Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 60401 invoked from network); 16 Nov 2007 01:13:00 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 16 Nov 2007 01:13:00 -0000 Received: (qmail 28183 invoked by uid 500); 16 Nov 2007 01:12:46 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 28158 invoked by uid 500); 16 Nov 2007 01:12:46 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 28147 invoked by uid 99); 16 Nov 2007 01:12:46 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 15 Nov 2007 17:12:46 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of amichail@gmail.com designates 209.85.132.246 as permitted sender) Received: from [209.85.132.246] (HELO an-out-0708.google.com) (209.85.132.246) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 16 Nov 2007 01:12:36 +0000 Received: by an-out-0708.google.com with SMTP id c3so173537ana for ; Thu, 15 Nov 2007 17:12:29 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; bh=gQ8kFtDAjXewJL0fciQdJUGOhnlWeMP0KaebvfPbWzs=; b=i+AZYKSpV/RS0ZaDX8tMK0otgE2Z6opHlMn/mazosgaGNB4CE5+1zlR7FjcdA1xc8CG1bXbo8wn3Bs/XAz3iJ/4wbO8EnZwRs4w67NFdHOWoV/HNzaCbc7brK7jlL+NyU/9Xxj0dISkJSCOQUste6FXfkrd/4TKkkYhPfgO1m8o= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=YLd9QL600YhPAMfqSO0WJkxvlv9s47mIIhvYYJ1fTjHa9MOjEXgdcbsPta2uUdNXeZbsR8vDI6n+aJ+guqNygSbAkUMlJGDdRUHYFrjygzBkfZDAFDckYAaZqVr18u7ZYaobp7fAabwEdFdIC0NES624QadgpusYX+CZenTCc5c= Received: by 10.100.171.10 with SMTP id t10mr1949229ane.1195174949250; Thu, 15 Nov 2007 17:02:29 -0800 (PST) Received: by 10.100.251.4 with HTTP; Thu, 15 Nov 2007 17:02:29 -0800 (PST) Message-ID: Date: Thu, 15 Nov 2007 20:02:29 -0500 From: "Amir Michail" To: "Derby Discussion" Subject: how to suppress similar rows while copying from one table to another? MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Checked: Checked by ClamAV on apache.org Hi, I would like to copy rows from one table to another while copying only the first row from sets of similar rows. In particular, for rows in which two particular fields are the same, I would like to copy only the first row in that set. The rows have more than these two fields. I know how to copy rows from one table to another, but how do I suppress similar rows in this way? Amir