I need to use several aggregate functions, including most of the built-in
aggregates (count, min, max, avg, etc.) as well as some custom aggregates
(standard deviation and various percentiles).
Is there any documentation or example on how to create custom aggregate
functions? I have found one
is that the community must agree on syntax for declaring
user defined aggregates.
Right now you can fake a user defined aggregate. An example of how to do
this can be found in the scores demo package in java/demo/scores. For
more details, please grep that subtree for getMedianTestScore.
Hope
.
*From:* Suavi Ali Demir [mailto:[EMAIL PROTECTED]
*Sent:* Monday, August 28, 2006 3:52 PM
*To:* Derby Discussion; [EMAIL PROTECTED]
*Subject:* RE: How to emulate multiple DISTINCT aggregates?
That query needs to be modified little bit. It does not work when
my
:[EMAIL PROTECTED]
Sent: Tuesday, August 29, 2006 2:43 AM
To: Derby Discussion
Subject: Re: How to emulate multiple DISTINCT aggregates?
I can confirm what Ali said because {3,3,3} is the result I also receive
on Derby.
However, it seems the correct result to me. Just think about
Hi,
When trying to use multiple DISTINCT aggregates in Derby:
/SELECT COUNT(distinct editable), COUNT( distinct visible )
FROM item/
the following error is reported:
/ERROR 42Z02: Multiple DISTINCT aggregates are not supported at this time./
For a simple query one could write:
/SELECT COUNT
-Original Message-
From: Robert Enyedi [mailto:[EMAIL PROTECTED]
Sent: Monday, August 28, 2006 10:58 AM
To: Derby Discussion
Subject: How to emulate multiple DISTINCT aggregates?
Hi,
When trying to use multiple DISTINCT aggregates in Derby:
/SELECT COUNT(distinct editable), COUNT
DISTINCT aggregates? Hi, When trying to use multiple DISTINCT aggregates in Derby: /SELECT COUNT(distinct editable), COUNT( distinct visible ) FROM item/ the following error is reported: /ERROR 42Z02: Multiple DISTINCT aggregates are not supported at this time./ For a simple query one could write
: Monday, August 28, 2006 3:52
PM
To: Derby Discussion;
[EMAIL PROTECTED]
Subject: RE: How to emulate
multiple DISTINCT aggregates?
That query needs to be modified little bit. It does notwork when
my table contains:
1
1
1
2
2
2