From: | David Johnston <polobo(at)yahoo(dot)com> |
---|---|
To: | Nick <nboutelier(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Return equal number of rows with same column value |
Date: | 2012-06-05 05:05:56 |
Message-ID: | FB0B833C-78E8-4769-96A6-004CB42257EF@yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Jun 4, 2012, at 21:06, Nick <nboutelier(at)gmail(dot)com> wrote:
> On Jun 4, 5:27 pm, Nick <nboutel(dot)(dot)(dot)(at)gmail(dot)com> wrote:
>> For the data...
>>
>> INSERT INTO test (id,val) VALUES (1,a);
>> INSERT INTO test (id,val) VALUES (2,a);
>> INSERT INTO test (id,val) VALUES (3,a);
>> INSERT INTO test (id,val) VALUES (4,a);
>> INSERT INTO test (id,val) VALUES (5,b);
>> INSERT INTO test (id,val) VALUES (6,b);
>>
>> How could I return an even amount of val? For example, I would like to
>> return this...
>>
>> 1 | a
>> 2 | a
>> 5 | b
>> 6 | b
>>
>> Since the least number of b vals is 2, Id like to limit the a columns
>> to return only 2
>
> Found something good. Now if I could only dynamically get that "2"
> least val.
>
> SELECT * FROM (
> SELECT ROW_NUMBER() OVER (PARTITION BY val ORDER BY val) AS r, t.*
> FROM test t
> ) x
> WHERE r <= 2
>
... where r <= (select min(select count(*) from test group by val))
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Markus | 2012-06-05 08:13:49 | Re: Procedural Languages |
Previous Message | Trevor Campbell | 2012-06-05 03:49:24 | Re: Trouble with plan statistics for behaviour for query. |