select 品名,sum(价格) as 价格 from TB
group by 品名
having sum(价格)>100select 品名,sum(价格) as 价格 into aa from TB
group by 品名
having sum(价格)>100
group by 品名
having sum(价格)>100select 品名,sum(价格) as 价格 into aa from TB
group by 品名
having sum(价格)>100
...
select 品名,@par = sum(价格) from TB
into #tem group by 品名 having sum(价格) > 100