这个语句该怎么写……

[scjb79]

我要对表的F2字段求和，但求和用的记录要求是根据字段F1排除重复的结果，一条语句该怎么写呢？请大虾们指点一下

[linzhisong]

select f1,sum(f2) from table group F1

[linzhisong]

select f1,sum(f2) from table group by F1

[CrazyFor]

TRY:
select sum (f2) from (select f1,mix(f2) f2 from table group by F1)

[comman_wang]

select DISTINCT f1,sum(f2) from table group by F1
采用DINSTINCT函数去除重复的记录

[CrazyFor]

select sum(f2) from (select f1,max(f2) f2 from table group by F1)aa

[pengdali]

select sum (f2) from (select f1,mix(f2) f2 from table group by F1) aa

or

select sum (f2) from (select distinct f1,f2 from table) aa

[benxie]

楼上的可以啦。
不知道这样可不可以， 你试试吧。。
select sum(f2) from table where f1 in (select distinct(f1) from table)

[weixiao51]

楼上的，不行，table 里有很多重复的 f1，

select sum(f2) from (select distinct(f1), f2 from table) A

[SophiaWang]

select sum(f2)
from
(select distinct f1,f2 from tablename)

[scjb79]

select sum (f2) from (select distinct f1,f2 from table)aa 可以了，谢谢大力兄。
不过还有个条件: t1表的f1内联到t2表的f1怎么把这两部分组和在一起呢？我试了一下
select sum (f2) from t1 inner join t2 on t1.f1=t2.f1 and t1.f1 like 'dddd%',(select distinct f1,f2 from table)aa 长时间不返回

[scjb79]

谢谢各位，请再帮忙看看啊，我顶

[CrazyFor]

TRY:
select sum (f2) from (select t1.f1,max(t2.f2) f2 from t1 inner join t2 on t1.f1=t2.f1 and t1.f1 like 'dddd%')aa

[ibanez550]

select a.f1,sum(a.f2) as f2
from (select distinct t2.f1,t2.f2 from t1 inner join t2 on t1.f1=t2.f1 and t1.f1 like 'dddd%') a
group by a.f1
按照这个思路就可以了

[chpeng]

select f1,F2=sum(IsNull(F2,0)) from table group by F1

[liuyunfeidu]

啊，来完了。

[scjb79]

ibanez550运行不了，返回错误信息
"the column prefix "t1" does not match with a table name or alias name used in the query."

[ibanez550]

select a.f1,sum(a.f2) as f2
from (select distinct t1.f1（这儿，条件的）,t2.f2 from t1 inner join t2 on t1.f1=t2.f1 and t1.f1 like 'dddd%') a
group by a.f1
你可以这样试试