On 22 February 2013 17:01, Steve Clark <sclark(at)netwolves(dot)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.