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就不行了。
...全文
1534打赏收藏
求一sql语句
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就不行了。
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