Search Postgresql Archives
Re: finding duplicate numbers in a select distinct statement
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
select count(*) AS count, error, ev_text FROM clients_event_log GROUP BY error, ev_text;
you can add 'HAVING count(*) > X'; , if you want to see only those with count above X, etc.
--
GJ
[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]