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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general