"Philipp Tölke" <ascii158@web.de> wrote in message
news:eg38ql$pqt$1@online.de...
> Bosconian <nobody@nowhere.com> schrieb:
>> I'm looking the latter, a count of distinct items.
>
> The Syntax is COUNT(DISTINCT foo)
>
> Cheers
> --
> Philipp Tölke
> PGP: 0x96A1FE7A

It's amazing what a difference moving one parenthesis makes. :-)

Many thanks.