http://bbs.mcmaster.ca/cgi-bin/leobbs.cgi?&MMN_position=41:41
and this:
http://bbs.mcmaster.ca/php/index.php?module=pagemaster&PAGE_user_op=view_page&PAGE_id=11&MMN_position=43:43
You can find something for summer sublet.
Table table
colA colB colC
------- -------- --------
a11 b11 c11
a11 b11 c22
a22 b11 c33
a33 b22 c44
try to get the following
colA colB colC
------- ----- -------
a11 b11 (c11 +c22)
a22 b11 c33
a33 b22 c44
In another word, I want to get the sum of colC with the distinct colA and...