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

From Albretch Mueller
Subject Re: DUPS in tables columns ERROR: column ". . . " does not exist
Date
Msg-id 9ef66fac0808300605w5aef537aw163824bc89e99e7a@mail.gmail.com
Whole thread Raw
In response to DUPS in tables columns ERROR: column ". . . " does not exist  ("Albretch Mueller" <lbrtchx@gmail.com>)
Responses Re: DUPS in tables columns ERROR: column ". . . " does not exist  (Lew <noone@lwsc.ehost-services.com>)
List pgsql-general
 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;
~
 Thanks
 lbrtchx

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: ERROR: relation . . . does not exist
Next
From: "Albretch Mueller"
Date:
Subject: Re: ERROR: relation . . . does not exist