求一sql语句

[zhuxiaojun2002]

id name company datetime
1 aa c1
2 bb c2
3 aa c1
4 aa c1

我要得到
name company count
aa c1 3
bb c2 1

SELECT name, count(*) AS Expr1,company
FROM table
GROUP BY name
我加上company就不行了。

[xeqtr1982]

declare @t table(id int,name varchar(10),company varchar(10))
insert into @t select 1,'aa','c1'
union all select 2,'bb','c2'
union all select 3,'aa','c1'
union all select 4,'aa','c1'

select [name],
company,
[count]=count(1)
from @t
group by [name],company

• 打赏
• 举报

回复 赞

[issgates]

SELECT name, company, count(*) AS Expr1
FROM table
GROUP BY name, company

• 打赏
• 举报

回复 赞

[love16]

group by 后面再加company!!
SELECT name, count(*) AS Expr1,company
FROM table
GROUP BY name,company

• 打赏
• 举报

回复 赞

[erbaocui]

带group by的SQL语号
select选定的列是{分组字段/聚合函数},不能是其它。
同意大家说的

• 打赏
• 举报

回复 赞