Where of an aggregate

From: vali(at)voxline(dot)ro
To: pgsql-sql(at)postgresql(dot)org
Subject: Where of an aggregate
Date: 2003-06-15 08:01:52
Message-ID: 200306150801.h5F81qj32555@webnew.voxline.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

HI!
Try this

select c.traffic from
(select sum(bytes) as traffic
from traffic_table
group by ip) c where c.traffic<(100*1024*1024);

Browse pgsql-sql by date

  From Date Subject
Next Message Julian Scarfe 2003-06-15 15:13:14 Ordering in an aggregate -- points to paths
Previous Message The Hermit Hacker 2003-06-15 00:39:23 Re: WHERE of an AGGREGATE ...