declare @tb table(name varchar(10),userid varchar(10))
insert @tb
select 'aa','bai' union all
select 'aa','chi' union all
select 'bb','xiaoming' union all
select 'bb','pang' union all
select 'aa','kk' union all
select 'cc','nn'select * from @tb
select name as 书名,count(name) as 次数 from @tb group by nameresult:
书名 次数
---------------------------
aa 3
bb 2
cc 1
insert @tb
select 'aa','bai' union all
select 'aa','chi' union all
select 'bb','xiaoming' union all
select 'bb','pang' union all
select 'aa','kk' union all
select 'cc','nn'select * from @tb
select name as 书名,count(name) as 次数 from @tb group by nameresult:
书名 次数
---------------------------
aa 3
bb 2
cc 1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货