如何根据列的第一位得进行group

[hbjmdx008]

如何根据列的第一位得进行group
如下例子
tableA
id pr

11105010001059 10
11105010001060 20
11105010001060 30
22205010001060 10
32205010001060 15

要得到

pr

60
10
15

[paoluo]

Select SUM(pr) As pr From tableA Group By id Order By id

[wangdehao]

select pr=sum(pr) from tb
group by left(id,1)

[gahade]

create table #(id varchar(50),pr int)
insert into #(id,pr)
select '11105010001059',10
union all select '11105010001060',20
union all select '11105010001060',30
union all select '22205010001060',10
union all select '32205010001060',15
select sum(pr) as pr from #
group by left(id,1)
drop table #

[paoluo]

汗，看錯了。

Select SUM(pr) As pr From tableA Group By Left(id,1) Order By id

[hbjmdx008]

多谢。原来这里也可以用left啊。

[playwarcraft]

id pr

11105010001059 10
11105010001060 20
11105010001060 30

-------------
為什麼要這3個相加,樓主沒說清楚,什麼規則?

[hbjmdx008]

因为第一位全是1