[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: count(distinct col) can't recognize distinct

Can you give a specific example of a query that doesn't do what you expect
it to do?

Michael Mior

Le mar. 13 nov. 2018 à 07:56, 大明 <zteny@xxxxxxxxxxx> a écrit :

> Hi Guys:
> I got a question why it can't recognize DISTINCT tag on COUNT(DISTINCT
> col) aggregation function sometimes.
> but it is not problem when my sql query statement have WHEN clause or one
> more aggregation functions.
> Best Regards
> Haochao Zhuang