Subject: | Re: single row query - progress
| Date: | Thu, 17 May 2018 05:38:47 +1000
| From: | Bernie van't Hof <berniev@bje.com.au>
| Newsgroups: | pnews.paradox-dos
|
oops! Good spot. Thank you.
A pdox inconsistency.
'average' and 'sum' have a 'unique' option.
'count' works the other way round with 'all' as the option.
I already fixed another bug. Can you see it? Hint: Not pdox related.
- Bernie
On 16/5/18 10:16 pm, Larry DiGiovanni wrote:
> Bernie van't Hof wrote:
>
>> CALC count all, calc 3 +2
>
>> count(DISTINCT `t3`.`Amt`) AS `Count of Amt`,
>
> Is that right? I thought CALC COUNT ALL counted duplicates. If so, COUNT(DISTINCT does
just the opposite.
>
> --
> Larry DiGiovanni
>
|