Re: limit based on count(*) - Mailing list pgsql-general

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