关于写sql语句

[fstao]

比如#t数据如下：

id     type    amount
1       A        10
2       B        20
3       c        30
4       A        40
5       c        70
6       d        60 

我要统计amount汇总，并且有多少明细行，如下数据：

type      amount   f1
A           50      2
B           20      1
C          100      2
d           60      1

说明一下，#t.type=A，则#t.f1=2，是由两行数据合计的(amount=10+40)；#t.type=B，则#t.f1=1，是由1行数据合计(amount=20)，其它同理，请问如何写sql语句？

[AcHerat]

select [type],sum(amount) amount,count(*) as f1
from #t
group by [type]

[昵称被占用了]

SELECT type,SUM(amount) AS amount,COUNT(1) AS f1
FROM #T
GROUP BY type

[liulonglong789]

select distinct [type] type,sum(amount) amount,count(type) f1 from #t
group by type

[liulonglong789]

select distinct [type] type,sum(amount) amount,count(type) f1 from #t
group by type

[xian_99223]

SELECT [TYPE],SUM([AMOUNT]) AMOUNT,COUNT(1) F1

FROM #t

GROUP BY [TYPE]

[开着拖拉机泡妞]

select 
    [type],
    sum(amount) [amount],
    count(*) as [f1]
from 
    #t
group by 
    [type]