select 查询问题？

[firstname]

表1

hr_no total（类型为folat）
001 20
001 30
001 5
002 40
002 50
我要得的结果：
hr_no alltotal(总和)
001 55
002 90
这个select 语句怎样写？

[htl258_Tony]

select hr_no,sum(total) total from tb group by hr_no

[csdyyr]

select hr_no,sum(total) as alltotal
from tb
group by hr_no

[htl258_Tony]

if object_id('tb') is not null
  drop table tb
go
create table tb([hr_no] varchar(10),[total] float)
insert tb select 1,20
insert tb select 1,30
insert tb select 1,5
insert tb select 2,40
insert tb select 2,50
go
select hr_no,sum(total) total from tb group by hr_no
/*
hr_no      total
---------- ----------------------
1          55
2          90

*/

[ChinaJiaBing]

select hr_no ,SUM(total) as alltotal from A
       group by hr_no 

[firstname]

谢谢，结了