T-SQL语法异常，

2013-06-25

T-SQL语法错误，求助！select@v1avg(b)from(selectc1,sum(c2) as bfromtgroup by c1havingsum(c2)@v2)提

T-SQL语法错误，求助！
select      @v1=avg(b)
from        (select  c1,sum(c2) as b
             from    t
             group by c1
             having   sum(c2)>=@v2);

提示有语法错误，不知原因，求高手解惑。

鞠躬！
[解决办法]
select      @v1=avg(b)
from        (select  c1,sum(c2) as b
             from    t
             group by c1
             having   sum(c2)>=@v2) a
[解决办法]
from(子查询，没有表别名)


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

[解决办法]

select      @v1=avg(b)
 from        (select  c1,sum(c2) as b
              from    t
              group by c1
              having   sum(c2)>=@v2) as t

[解决办法]
在MSSQL里面FROM后面跟的是表名，在楼主的例子当中，后面的子查询就是作为一个表在使用。。所以要给后面的子查询一个表名
如下：
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;

试试

热点排行

SQL Server

T-SQL语法异常，