Re: [GENERAL] finding duplicate numbers in a select distinct statement

2010/3/3 Terry : > 2010/3/3 Grzegorz Jaśkiewicz : >> 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 >> > > I was just about to reply to

Re: [GENERAL] finding duplicate numbers in a select distinct statement

just try if it does what you want it to do ;)

Re: [GENERAL] finding duplicate numbers in a select distinct statement

2010/3/3 Grzegorz Jaśkiewicz : > 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 > I was just about to reply to the group. Would this work too

Re: [GENERAL] finding duplicate numbers in a select distinct statement

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