Re: limit based on count(*)

[Steve Clark <sclark@xxxxxxxxxxxxx>]

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, didn't know about having - I am noobie with SQL.

--
Stephen Clark