Re: [GENERAL] Return equal number of rows with same column value

On Jun 4, 2012, at 21:06, Nick wrote: > On Jun 4, 5:27 pm, Nick 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) V

[GENERAL] Return equal number of rows with same column value

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?

Re: [GENERAL] Return equal number of rows with same column value

On Jun 4, 5:27 pm, Nick 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