SELECT SUM(xiaoshu) AS zongxiaoshu, SUM(chenben) AS zongchenben, SUM(maoli) AS zongmaoli
FROM A
语法是对的呀!
select max(bianhao) as bianhao,max(ypname) as ypname,sum(xiaoshu)as xiaoshu,sum(chenben) as chenben,sum(maoli) as maoli from maoli group by bianhao
的语法也是对的呀!
FROM A
语法是对的呀!
select max(bianhao) as bianhao,max(ypname) as ypname,sum(xiaoshu)as xiaoshu,sum(chenben) as chenben,sum(maoli) as maoli from maoli group by bianhao
的语法也是对的呀!
解决方案 »
- 基本查询语句求指教
- 求SQL语句一条,有实力的来
- 邹建哥,请进来!真是急死人呐(没分了)
- SQL2005打开作业属性,总弹出新建作业窗口,急!!!
- 在事务里使用exec (@sql) 向另一个表写记录,这样事务会起到作用使这个语句也可以rollback吗
- 用char或varchar型长为10如果我只存了4个字节那么是不是也占用10个字节的长度?
- 关于SQL SERVER里处理字符串的问题
- 为什么这个存储过程不执行 ???
- 跟贴:下贴类似问题,很简单.已经是100分+100分了.还是没有人回复?
- 如何使用日志文件恢复数据库,在线等!!急,急,急
- 请问怎样用sql server中数据库生成结构相同的access文件?
- 晕,花好几天搞的东东,今天居然发现不能用SQL实现。天啊!!!!!!!放分!!!
Line 2: Incorrect syntax near ')'
----------------------------------------
SELECT SUM(xiaoshu) AS zongxiaoshu, SUM(chenben) AS zongchenben, SUM(maoli) AS zongmaoli
FROM (select max(bianhao) as bianhao,max(ypname) as ypname,sum(xiaoshu)as xiaoshu,sum(chenben) as chenben,sum(maoli) as maoli from maoli group by bianhao)
SELECT SUM(xiaoshu) AS zongxiaoshu, SUM(chenben) AS zongchenben, SUM(maoli) AS zongmaoli from(
select max(bianhao) as bianhao,max(ypname) as ypname,sum(xiaoshu)as xiaoshu,sum(chenben) as chenben,sum(maoli) as maoli from maoli group by bianhao) aa
吗?
FROM (select max(bianhao) as bianhao,max(ypname) as ypname,sum(xiaoshu)as xiaoshu,sum(chenben) as chenben,sum(maoli) as maoli from maoli group by bianhao) aaaaaa