Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux