Question on "select count(distinct...)

Posted in 1999

Viegas, John — Mon, 1 Feb 1999 14:32:07 -0500 — source: Informix-list mailing list archive (1991-1998)

I have a programmer trying to get a count of the distinct occurrences of three columns. They have tried the following with no luck: Select count (distinct column_a, column_b, column_c) NOGOOD Select count (distinct column_a||column_b||column_c) NOGOOD They did however make it quite clear that this worked in Oracle. Can anyone shed some light so I can save Informix's Reputation. Thanks John Paul