34,593
社区成员
发帖
与我相关
我的任务
分享
select xm,avg(gz001+gz002+gz004+gz005+gz006+gz007+gz008+gz009+gz010+gz012+gz014+gz017+gz018+gz021+gz023+gz025) as gzze,
count(xm) as tjhs
from gzcw
where left(gz072,4)='2008'
group by xm
order by xm
select xm,avg(gz001+gz002+gz004+gz005+gz006+gz007+gz008+gz009+gz010+gz012+gz014+gz017+gz018+gz021+gz023+gz025) as gzze,
count(1) as tjhs
from gzcw
where left(gz072,4)='2008'
group by xm
order by xm
--這個?
select @@rowcount