Skip site navigation (1) Skip section navigation (2)

Re: DUPS in tables columns ERROR: column ". . . " does not exist

From: Lew <noone(at)lwsc(dot)ehost-services(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: DUPS in tables columns ERROR: column ". . . " does not exist
Date: 2008-08-31 16:14:45
Message-ID: K_SdnaoWcKroXifVnZ2dnUVZ_oqdnZ2d@comcast.com (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-general by date

Next:From: LewDate: 2008-08-31 16:17:42
Subject: Re: integer values in conf file
Previous:From: LewDate: 2008-08-31 16:06:53
Subject: Re: ERROR: relation . . . does not exist

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group