Re: Question on "select count(distinct...)

Posted in 1999

Woodall Con — Mon, 1 Feb 1999 13:15:53 -0700 (MST) — source: Informix-list mailing list archive (1991-1998)

How about: count (*), column_a||column_b||column_c column_a_b_c group by 2 order by 2 Good luck Con Woodall Colorado State University Veterinary Teaching Hospital cwoodall@vth.colostate.edu 970-491-1244 On Mon, 1 Feb 1999, Viegas, John wrote: > 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) NO> GOOD > Select count (distinct column_a||column_b||column_c) NO> GOOD > > 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 >