Re: SQL: count distinct multi-column

Posted in 1997

Carlos Antonio Ruiz Gomez — 6 Aug 1997 09:48:31 -0400 — source: Informix-list mailing list archive (1991-1998)

> In SQL, is there a way to count the number of rows that have distinct > multi-column keys? It seems that the count function does not accept a > distinct expression with multiple columns. Every time I need the same thing, I use the following commands: SELECT DISTINCT k1,k2,k3 FROM tbl INTO TEMP tmp_tbl; SELECT COUNT(*) FROM tmp_tbl; ------------------------- Carlos Antonio Ruiz G'mez dmys2@colomsat.net.co Santaf' de Bogot' D. C. Colombia, Suram'rica