declare @TableA table (name varchar(20)) insert into @TableA select '张三' union all select '李四' union all select '李四' union all select '王五' union all select '张三' union all select '李四' select name ,count(name) as 数量 from @TableA group by name--name 数量 --李四 3 --王五 1 --张三 2=========================================================================================
错误提示:在Table附近有语法错误。
select name, count(*) ct
from [表名]
group by name
还是提示,TABLE附近语法错误
例如:
aaaaa11
444aaaaa
33aaaaa
aaaaa44要什么样的结果?
是aaaaa 4
还是
aaaaa* 2
*aaaaa 2
insert into @TableA
select '张三' union all
select '李四' union all
select '李四' union all
select '王五' union all
select '张三' union all
select '李四'
select name ,count(name) as 数量 from @TableA group by name--name 数量
--李四 3
--王五 1
--张三 2=========================================================================================