On 02/22/2013 11:14 AM, Russell Keane 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
> having count(*) > X
> order by restarts
I think having is the better option.
Thanks all, did
> 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
I think having is the better option.
> Hello List,
>
> I have a query that counts how many time an event occurs in our event_log
> these are grouped by the serial number of the device that created the event.
> I would like to show only the rows where the number of events exceeds some
> threshold.
>
> simplified query:
> select ser
On 22 February 2013 17:01, Steve Clark 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
ilik
