--创建临时表#temp
create table #temp -- select * from #temp drop table #temp
([name] varchar(36)
,num int)
--插入测试数据
insert into #temp
select 'A','2'
union all
select 'A','3'
union all
select 'B','4'
union all
select 'C','8'
union all
select 'A','6'
--执行操作
select [name]
,avg(num) as [avg]
,max(num) as [max]
,min(num) as [min]
from #temp
group by [name]
order by [name]
--结果
[name] [avg] [max] [min]
A 3 6 2
B 4 4 4
C 8 8 8
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024