Re: limit based on count(*)

[Alban Hertroys <haramrae@xxxxxxxxx>]

On 22 February 2013 17:01, Steve Clark <sclark@xxxxxxxxxxxxx> 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.