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

From: "Albretch Mueller" <lbrtchx(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: DUPS in tables columns ERROR: column ". . . " does not exist
Date: 2008-08-30 13:05:50
Message-ID: 9ef66fac0808300605w5aef537aw163824bc89e99e7a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albretch Mueller 2008-08-30 13:26:44 Re: ERROR: relation . . . does not exist
Previous Message Martijn van Oosterhout 2008-08-30 12:53:52 Re: ERROR: relation . . . does not exist