count distinct

Posted in 1998

Ilia Perminov — 12 Oct 1998 17:03:45 +0400 — source: Informix-list mailing list archive (1991-1998)

Hi all, Could anybody explain my why I can't use more the one "count (distinct ...)" in a query? For example, select count (distinct a), count (b) from a_table is a correct query, but select count (distinct a), count (distinct b) from a_table is not a correct one (Informix: 201: A syntax error has occurred.). I have not found anything about this restriction in Informix Guides. Ilia