求一句SQL语句，统计总和。 (天天问现金任务)(0分)

表数据如下：<br><br>编号 数量1 数量2 地点 相关人员<br>1 &nbsp; &nbsp; 3 &nbsp; &nbsp; 3 &nbsp; &nbsp; A &nbsp; &nbsp; &nbsp;1<br>2 &nbsp; &nbsp; 5 &nbsp; &nbsp; 8 &nbsp; &nbsp; B &nbsp; &nbsp; &nbsp;2<br>3 &nbsp; &nbsp; 4 &nbsp; &nbsp; 4 &nbsp; &nbsp; A &nbsp; &nbsp; &nbsp;1<br>4 &nbsp; &nbsp; 6 &nbsp; &nbsp; 2 &nbsp; &nbsp; C &nbsp; &nbsp; &nbsp;3<br>5 &nbsp; &nbsp; 7 &nbsp; &nbsp; 4 &nbsp; &nbsp; C &nbsp; &nbsp; &nbsp;3<br>……<br><br>要求：<br><br>计算数量1和数量2的总和，但是如果在同一地点，并且相关人员也是同一人的话，则数量肯定是相同的，只能增加一次。<br>意思就是要排除掉重复的地点和相关人员，再计算出数量1和数量2的总和。<br><br>最好是一句SQL就搞定，谢谢。<br><br>任务地址：<br>http://www.ttwen.com/mission_read.asp?MissionID=276

select 数量1+数量2 form Table &nbsp;group by 地点,相关人员

Select Sum(数量1+数量2) From (Select distinct 数量1,数量2,地点,相关人员 From 表)a

4 &nbsp; &nbsp; 6 &nbsp; &nbsp; 2 &nbsp; &nbsp; C &nbsp; &nbsp; &nbsp;3<br>5 &nbsp; &nbsp; 7 &nbsp; &nbsp; 4 &nbsp; &nbsp; C &nbsp; &nbsp; &nbsp;3<br>要取那条记录？

这个有点笔误。表数据是随手写的。<br>如果在同一地点，并且相关人员也是同一人的话，则数量肯定是相同的

select sum(数量1+数量2) from <br>(select &nbsp;max(数量1) as 数量1,max(数量2) as 数量2, 地点, 相关人员 from 表 group by 地点, 相关人员 ) a

select sum(数量1+数量2)/count(0) from Table group by 地点,相关人员

select sum(数量1) 总数量,地点,相关人员 from Table group by 地点,相关人员 having count(0)=1 <br>union all<br>select sum(数量1+数量2)/2 总数量,地点,相关人员 from Table group by 地点,相关人员 having count(0)&gt;1

djs00717的可以算出结果了<br>也多谢迷途的羔羊帮忙[]

i'm coming late.mark!