求和SQL

create table test1
(id int,name nvarchar(100),[desc] nvarchar(100),coin float,createts datetime)

insert into test1 values
(101,'tom','C',100,'2013-02-23 22:17:28.000'),
(102,'tom','A C',10,'2013-02-23 22:17:28.000'),
(103,'PETER','C',50,'2013-02-23 21:51:55.000'),
(104,'MARY','C',80,'2013-02-23 21:06:48.000'),
(105,'MARY','A C',20,'2013-02-23 21:06:48.000')

desc列为'C'表示这是一条充值记录，为'A C'表示这条记录是充值额外赠送的


要求当name列和createts列相同时合并coin列得到以下结果

idnamecoincreatets
101tom1102013-02-2322:17:28.000
103PETER502013-02-23 21:51:55.000
104MARY1002013-02-23 21:06:48.000

[解决办法]

select id=min(id),name,coin=sum(coin),createts from test1 group by name,createts order by min(id)

[解决办法]
首先建议你才coin字段既然涉及到金额不要用float，float是近似类型，不精确
要用decimal或者numeric，金融类的可以用money类型

select min(id)id,name,sum(coin)coin,createts from tb group by name,createts