2010/11/2 Bill Reynolds :
> I’m using postgres 8.3.7.
that's a pity because in 8.4 we have window functions which make this
possible in one query:
select * from (
select x, y, count(*) as counter,
row_number() over(partition by x order by count(*)) rn
from mytable
group by x, y order b
Hey Folks - have a coded myself into a corner yet?
I have a situation with a select count / group by / order by query that
I need to limit each group to 500 entries. Not seeing a way to do this
in a single query, do I need to use multiple queries?
Group x has about 200 entries in it; group y
