select branch_name, avg(balance)
from account
group by balance_name
as branch_avg(branch_name, avg_balance)
报错:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near
'as branch_total(branch_name, tot_balance)'
at line 1不支持as子句关系和属性一起命名么?怪了
from account
group by balance_name
as branch_avg(branch_name, avg_balance)
报错:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near
'as branch_total(branch_name, tot_balance)'
at line 1不支持as子句关系和属性一起命名么?怪了
解决方案 »
- 关于in和exists的优化问题,搜索无准确结果,在MYSQL
- 请教有没有好的工具或者方法用于观察和比较数据库变化
- 根据投票结果统计相似指数用户算法问题
- mysql install failure
- 创建表的时候能否决定主键的索引类型?
- 请问各位老大:在MS SQL Server中能正确运行的Update语句,到My SQL中后要作何修改?
- MySQL中prepareStatement()方法抛出空值异常?
- [order by]关于提高排序速度的几个疑惑
- mysql在linux下安装,请问怎么卸载呀,我想重新装
- MYSQL重启后马上自动挂,急求解
- Mysql 设置foreign key 目的是什么?
- 新手请教,mysql创建触发器语法错误
'截至2011-11-06 16:41:47 用户结帖率0.00%当您的问题得到解答后请及时结贴.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
http://topic.csdn.net/u/20100428/09/BC9E0908-F250-42A6-8765-B50A82FE186A.html
http://topic.csdn.net/u/20100626/09/f35a4763-4b59-49c3-8061-d48fdbc29561.html8、如何给分和结贴?
http://community.csdn.net/Help/HelpCenter.htm#结帖
as
select branch_name, avg(balance)
from account
group by balance_name