Postgres Pro
Downloads
Home   >   mailing lists

Re: finding duplicate numbers in a select distinct statement - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: finding duplicate numbers in a select distinct statement
Date
Msg-id 2f4958ff1003030700v8a56701icc2e891bdb24814a@mail.gmail.com
Whole thread Raw
In response to finding duplicate numbers in a select distinct statement  (Terry <td3201@gmail.com>)
Responses Re: finding duplicate numbers in a select distinct statement  (Terry <td3201@gmail.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Kevin Kempter
Date:
Subject: Re: How to grant a user read-only access to a database?
Next
From: Terry
Date:
Subject: Re: finding duplicate numbers in a select distinct statement