请问一个sql的查询，有难度

请教一个sql的查询，有难度。
序号 卡号 支付金额 受理日 创建日期
337689600000000710464201008202010/8/20 13:43:41
2676896000000006459422.50201008202010/8/20 13:41:08
2768960000000062025965.75201008202010/8/20 11:54:24
117689600000000436532201008202010/8/20 11:56:02
107689600000000436532201008202010/8/20 11:56:02
137689600000000436532201008202010/8/20 11:56:03
127689600000000436532201008202010/8/20 11:56:03
77689600000000436532201008202010/8/20 11:55:56
87689600000000436532201008202010/8/20 11:55:57
67689600000000418423163.00201008202010/8/20 11:55:42
1876896000000000001480.01201008202010/8/20 11:57:50
1976896000000000001480.01201008202010/8/20 11:58:26
2576896000000000001480.01201008202010/8/20 12:02:00
576896000000000001480.01201008202010/8/20 11:55:07
376896000000000001480.01201008202010/8/20 11:54:35
2776895100530000105091517.00201008202010/8/20 13:41:56
317689510053000010509201008202010/8/20 13:43:02
327689510053000010509201008202010/8/20 13:43:09
17768950021000002951531.00201008202010/8/20 11:57:45
28768950021000001996142.00201008202010/8/20 13:42:00
47689500210000009541201008202010/8/20 11:54:53
21768950021000000453428.00201008202010/8/20 12:00:12
247689500210000004534201008202010/8/20 12:01:09
3476892000101726124750.0220111182010/12/22 16:57:38
1768920001010105963296.00201008202010/8/20 11:54:00
237689200010101013092201008202010/8/20 12:00:49
227689200010101013092201008202010/8/20 12:00:48
97689200010100848563201008172010/8/17 12:21:43
207689200010100780709201008192010/8/19 20:05:56
157689200010100151687201008202010/8/20 11:57:44
167689200010100151687201008202010/8/20 11:57:44
14768910037300011688271.10201008202010/8/20 11:56:33
... .... ... ... ...

我想把同一卡号的金额统计统计到一起，应该怎么做？
如卡号为7689600000000000148 金额为 0.01+0.01+0.01+0.01+0.01=0.05
卡号非常多。

[解决办法]
select t.卡号,sum(t.金额)
from table_t t
group by t.卡号
[解决办法]

SQL code

--???select 卡号,sum(支付金额) 支付金额 from t group by 卡号;
[解决办法]
如只是某一类卡号：
select sum(支付金额) from tabnam where 卡号 = '7689600000000000148'
[解决办法]
探讨

引用:

select t.卡号,sum(t.金额)
from table_t t
group by t.卡号

我有n多卡号我不可能全部写完！

[解决办法]
SQL code
select 卡号,        sum(支付金额) 支付金额 from tb1 group by 卡号;