Re: DUPS in tables columns ERROR: column ". . . " does not exist - Mailing list pgsql-general

Albretch Mueller wrote:
>  Also I know there is a DISTINCT keyword, but I also need to know how
> many times the particular data in the column is repeated if it is,
> that is why I need to go:
> ~
>  SELECT md5, COUNT(md5) AS md5cnt
>  FROM jdk1_6_0_07_txtfls_md5
>  WHERE (md5cnt > 1)
>  GROUP BY md5
>  ORDER BY md5cnt DESC;

Use HAVING instead of WHERE.

--
Lew