PHP query join question

Question

if i have a table that looks like this:

sample_id   date       sample_number
12          1-24-10    5
09          1-25-10    2
12          2-14-10    5

How can I join both (sample_id:12)'s ?

sample_id:12 has a total of 10 sample numbers.

jasonbar · Accepted Answer · 2010-02-26 03:37:10Z

4

SELECT SUM(`sample_number`) FROM `table` GROUP BY `sample_id`;

Should do it.

answered Feb 26, 2010 at 3:37

jasonbar

13.5k4 gold badges41 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1