Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 73961 invoked from network); 2 Nov 2005 15:53:47 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 2 Nov 2005 15:53:47 -0000 Received: (qmail 98048 invoked by uid 500); 2 Nov 2005 15:53:46 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 98027 invoked by uid 500); 2 Nov 2005 15:53:45 -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 98016 invoked by uid 99); 2 Nov 2005 15:53:45 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Nov 2005 07:53:45 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [204.127.202.64] (HELO sccrmhc13.comcast.net) (204.127.202.64) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Nov 2005 07:53:41 -0800 Received: from [127.0.0.1] (pcp0011932243pcs.summit01.nj.comcast.net[69.249.77.51]) by comcast.net (sccrmhc13) with ESMTP id <200511021553220130044r5re>; Wed, 2 Nov 2005 15:53:22 +0000 Message-ID: <4368E0E3.1080800@neometsys.fr> Date: Wed, 02 Nov 2005 10:53:07 -0500 From: Nicolas Dufour User-Agent: Thunderbird 1.4.1 (Windows/20051004) MIME-Version: 1.0 To: Derby Discussion Subject: functions and list Content-Type: multipart/mixed; boundary="------------040306000301050203050106" X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. --------------040306000301050203050106 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hi I wonder how I can create an aggregate function like count or max ? The idea is i want to process in the same time a list of row and return something. For example, I need to get from a list of flights (rows of table flight) the average delay. Is it possible in Derby and how ? Thank you Nicolas --------------040306000301050203050106 Content-Type: text/x-vcard; charset=utf-8; name="nicolas.dufour.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="nicolas.dufour.vcf" begin:vcard fn:Nicolas Dufour n:Dufour;Nicolas org:NeoMetSys;Linux adr:;;7 rue du theatre;Massy;;91300;France email;internet:nicolas.dufour@neometsys.fr title:Consultant tel;work:+1 973 379 3522 x-mozilla-html:FALSE url:http://www.neometsys.fr/ version:2.1 end:vcard --------------040306000301050203050106--