帮写个sql语句.

[xaojancsdn]

有如下表:
field1 field2.....

A123
B36.6
B251.2
C417.a
A111
F21.3
A255
.
.
.
我现在如何得到字段field1中各首字母相同的记录数?

[welyngj]

select left(field,1),sum(field2)as sum1 from bb group by right(field,1)

[welyngj]

上面的错了，将 sum(field2) 改为count(*)
即select left(field,1),count(*)as sum1 from bb group by right(field,1)

[伍子V5]

select sum(1)as sum from table group by left(field1,1)

[pengdali]

select left(field,1),count(*)as sum1 from bb group by left(field,1)

[xaojancsdn]

试一下先

[xaojancsdn]

通不过，提示：
“因为该列不含在聚合函数中。。。“

[lfengxu]

select left(field1,1),count(*)as sum from bb group by left(field1,1)

[xaojancsdn]

谢谢，通过了。
select left(field,1),sum(field2)as sum1 from bb group by right(field,1）
这句通不过。left才对。

[dafu71]

select left(field,1),sum(1)as sum1 from bb group by left(field,1)