假如有该表 a
id code name guige riqi
1 123 abcd good 123
2 123 abcd good 29
3 124 aadd good 123
查询结果如下
code name guige shuliang(数量)
123 abcd good 2
124 aadd good 1
求解答
在线等！！
SQL code:
select code , name , guige , shuliang = count(1) from a group by code , name , guige
SQL code:
select
code,name,guige,count(1) as shuliang
from
tb
group by
code,name,guige
SQL code:
declare @tb table([id] int,[code] int,[name] varchar(4),[guige] varchar(4),[riqi] int)
insert @tb
select 1,123,'abcd','good',123 union all
select 2,123,'abcd','good',29 union all
select 3,124,'aadd','good',123
select code, name, guige, count(*) as shuliang
from @tb
group by code, name, guige
/*
code name guige shuliang
----------- ---- ----- -----------
123 abcd good
