On 22 February 2013 17:01, Steve Clark <scl...@netwolves.com> wrote: > select serial_no, count(*) as "restarts" from event_log where event_mesg > ilike 'system sta%' and event_date > current_date - 7 > group by serial_no order by restarts >
select serial_no, count(*) as "restarts" from event_log where event_mesg ilike 'system sta%' and event_date > current_date - 7 group by serial_no having count(*) > X order by restarts -- If you can't see the forest for the trees, Cut the trees and you'll see there is no forest.
