select @v1=avg(b)
from (select c1,sum(c2) as b
from t
group by c1
having sum(c2)>=@v2);提示有语法错误,不知原因,求高手解惑。鞠躬!
from (select c1,sum(c2) as b
from t
group by c1
having sum(c2)>=@v2);提示有语法错误,不知原因,求高手解惑。鞠躬!
调试欢乐多
from (select c1,sum(c2) as b
from t
group by c1
having sum(c2)>=@v2) a
select @v1=avg(b) from
(
select c1,sum(c2) as b
from t
group by c1
having sum(c2)>=@v2)
)a
declare @v1 int,@v2 int
select @v1=avg(b) from
(
select c1,sum(c2) as b from t
group by c1 having sum(c2)>=@v2
)a
from (select c1,sum(c2) as b
from t
group by c1
having sum(c2)>=@v2) as t
如下:
declare @v1 int
declare @v2 int
select @v1=avg(b)
from (select c1,sum(c2) as b
from t
group by c1
having sum(c2)>=@v2)a;试试