Postgres Pro
Downloads
Home   >   mailing lists

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

From Russell Keane
Subject Re: limit based on count(*)
Date
Msg-id 8D0E5D045E36124A8F1DDDB463D548557D1618F4D4@mxsvr1.is.inps.co.uk
Whole thread Raw
In response to Re: limit based on count(*)  (Alban Hertroys <haramrae@gmail.com>)
Responses Re: limit based on count(*)
List pgsql-general
Tree view 
> 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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Need help extripating plpgsql
Next
From: Steve Clark
Date:
Subject: Re: limit based on count(*)