Return-Path: X-Original-To: apmail-db-derby-user-archive@www.apache.org Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 4B7EE10E57 for ; Tue, 3 Dec 2013 02:10:29 +0000 (UTC) Received: (qmail 55415 invoked by uid 500); 3 Dec 2013 02:10:29 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 55393 invoked by uid 500); 3 Dec 2013 02:10:29 -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 55381 invoked by uid 99); 3 Dec 2013 02:10:29 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Dec 2013 02:10:29 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy includes SPF record at spf.trusted-forwarder.org) Received: from [216.139.236.26] (HELO sam.nabble.com) (216.139.236.26) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Dec 2013 02:10:24 +0000 Received: from tom.nabble.com ([192.168.236.105]) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1VnfR5-00042R-0u for derby-user@db.apache.org; Mon, 02 Dec 2013 18:10:03 -0800 Date: Mon, 2 Dec 2013 18:10:03 -0800 (PST) From: Bob M To: derby-user@db.apache.org Message-ID: <1386036603019-135869.post@n7.nabble.com> In-Reply-To: <529D355C.5050105@gmail.com> References: <1385998212051-135855.post@n7.nabble.com> <1386010968408-135863.post@n7.nabble.com> <529D355C.5050105@gmail.com> Subject: Re: Problem retrieving the 'oldest' record MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Bryan Only four records in my 4,100 records have the same date field but the time field for each of these four records is 0, 6, 12, and 18 respectively. Therefore I believe my key is unique. In addition, it is 'natural' which is much more useful to me when I read the data And so, I still have my original question................... Why does my code not pick up the true 'oldest' record ???? Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Problem-retrieving-the-oldest-record-tp135855p135869.html Sent from the Apache Derby Users mailing list archive at Nabble.com.