高手帮忙 sql语句

作者：hbutwzc 来源：不详发布时间：2008/07/29 发布人：admin

hbutwzc 发布留言 2008-7-29 09:47

高手帮忙 sql语句

use mineBCA
go
SELECT a.MAKTXX as maktxx, Count(a.CHEHAO) AS ch, Sum(a.MZQTY)-Sum(a.PZQTY) as sz, Sum(a.jZQTY) AS jz from (select * from zjlrestmp where Left(CZDAT,8)='20080723' and bfname= '经纬'and BWTAR=0 and pzflag=0 ) as g where MAKTXX='氧化铝' as a group by a.maktxx

在查询分析器中为什么老显示在AS附件有错误，我又找不到在什么地方！

makebest 发布留言 2008-7-29 10:57

where MAKTXX='氧化铝' as a

xinzheng 发布留言 2008-7-29 15:51

use mineBCA
go

select MAKTXX,count(CHEHAO) AS ch, Sum(MZQTY)-Sum(PZQTY) as sz, Sum(jZQTY) AS jz from zjlrestmp where Left(CZDAT,8)='20080723' and bfname= '经纬'and BWTAR=0 and pzflag=0 and MAKTXX='氧化铝' group by MAKTXX

页: [1]

特别说明：如网页特效代码中有引用图片文件等，请自己下载到本地调试！

[] [返回] [打印] [收藏] [评论]

上一篇代码：excel to sql2005

下一篇代码：新手学习SQL SERVER 2055

高手帮忙 sql语句

高手帮忙 sql语句

精品推荐

代码分类

阅读排行

相关代码