这个Sql语句如何写？

[honpher]

sql2000表中有以下三行数据：

name client count
penA zt 5
penB kl 6
penA es 7
penB sd 9

要利用sql语句统计成
name count
penA 12
penB 15


请问如何写sql语句

[honpher]

name 是text类型，是否不能用order by? 执行时报错了：

不能比较或排序　text　数据类型，除非使用　IS　NULL　或LIKE

[honpher]

name 是text类型，是否不能用order by? 执行时报错了：

不能比较或排序　text　数据类型，除非使用　IS　NULL　或LIKE

[--小F--]

--试下这个select cast([name] as varchar),[count]=sum([count]) from tb 
group by [name] 
order by [name]

[--小F--]

--试下这个
select cast([name] as varchar),[count]=sum([count]) from tb 
group by [name] 
order by [name]

[InsistOnDoing]

大家都回答了，我就帮顶下

[chinamis2008]

select [name]=cast([name] as varchar(max)) ,[count]=sum([count]) from a 
group by cast([name] as varchar(max)) 
order by cast([name] as varchar(max)) ,[count]

如果是text 类型，可以这样做

[lqiang83]

学习

[nick40827]

学习

[IamstudyingJava]

如果是系统保留字，就要加[]

[-无-为-]

学习了...

[youzhj]

学习学习

[olddown]

以前碰过存储过程的名字是中间加小数点的，不用[]括起来怎么都删不掉，系统总是把它当作两个名字，后来发现[]的好处。。。。

[tengjian1981]

select cast([name] as varchar),[count]=sum([count]) from tb 
group by cast([name] as varchar) 
order by cast([name] as varchar)

[tshf198556]

select [name],[count]=sum([count]) from tb
group by [name]
order by [name]
count 要加[]

[sky492420669]

select name,count(*) from tb group by name;
这样就可以了，你试试！

[conan304]

[Quote=引用楼主 honpher 的帖子:]
sql2000表中有以下三行数据：

name client count
penA zt 5
penB kl 6
penA es 7
penB sd 9

要利用sql语句统计成
name count
penA 12
penB 15


请问如何写sql语句
[/Quote]

select [name],isnull(sum([count]),0) as 'count'
from tableName
group by [name]
order by 1

[SQL77]

select CONVERT(VARCHAR,[name]) AS [NAME],isnull(sum([count]),0) as 'count'
from tableName
group by [name]
order by 1

是TEXT型就转换成字符型

[有多少爱可以重来]

select name,sum(count) as count from table group by name

[sfplGood]

[Quote=引用 3 楼 sdhdy 的回复:]
引用 2 楼 sdhdy 的回复:
SQL codeselect [name],[count]=sum([count]) from tb
group by [name]
order by [name]

name和count都是SQL SERVER的保留字或关键字，不建议作为字段或对象名称，用的时候要在两边加[]
[/Quote]

学习了！

[lwilson]

select [name],[count]=sum([count]) from test
group by [name]
order by [name]