VIP会员
购物车
私信
发表新帖
立即签到
关注
回复
支持(
反对( 首页上一页 1 下一页尾页 1 条记录 1/1页
分组统计问题 补充 再请教
发表在VB答疑区
2008-11-04
是否精华
是
否
版块置顶:
是
否
您好
分组统计问题 补充 蒙您的指教 万分感谢。
按您所教给‘GROUP BY子句加参数 with rollup’后，运行中提示‘WITHOWNERACCESSOPTION说明中语法错误’。
原"select SJ1,sum(SJ2) AS SJ2,sum(SJ3) AS SJ3,sum(SJ4) AS SJ4," _
& "sum(SJ5) AS SJ5 from ARR group by SJ1 with rollup order by SJ1" 运行时数据表最后一行漏掉不统计
改为
"select SJ1,sum(SJ2) AS SJ2,sum(SJ3) AS SJ3,sum(SJ4) AS SJ4," _
& "sum(SJ5) AS SJ5 from ARR group by SJ1 with rollup order by SJ1" 运行中提示‘WITHOWNERACCESSOPTION说明中语法错误’。
上次回复
您好，需要给GROUP BY子句加如参数 with rollup。
将查询语句改为"select SJ1,sum(SJ2) AS SJ2,sum(SJ3) AS SJ3,sum(SJ4) AS SJ4," _
& "sum(SJ5) AS SJ5 from ARR group by SJ1 with rollup order by SJ1"
请您再费心替我看一下好吗
谢谢
分组统计问题 补充 蒙您的指教 万分感谢。
按您所教给‘GROUP BY子句加参数 with rollup’后，运行中提示‘WITHOWNERACCESSOPTION说明中语法错误’。
原"select SJ1,sum(SJ2) AS SJ2,sum(SJ3) AS SJ3,sum(SJ4) AS SJ4," _
& "sum(SJ5) AS SJ5 from ARR group by SJ1 with rollup order by SJ1" 运行时数据表最后一行漏掉不统计
改为
"select SJ1,sum(SJ2) AS SJ2,sum(SJ3) AS SJ3,sum(SJ4) AS SJ4," _
& "sum(SJ5) AS SJ5 from ARR group by SJ1 with rollup order by SJ1" 运行中提示‘WITHOWNERACCESSOPTION说明中语法错误’。
上次回复
您好，需要给GROUP BY子句加如参数 with rollup。
将查询语句改为"select SJ1,sum(SJ2) AS SJ2,sum(SJ3) AS SJ3,sum(SJ4) AS SJ4," _
& "sum(SJ5) AS SJ5 from ARR group by SJ1 with rollup order by SJ1"
请您再费心替我看一下好吗
谢谢
分享到：
