SELECT pt.project_id, pt.project_name, ROUND(sum(allC), 2) v1, ROUND(sum(allF), 2) allF, (SELECT v1) t FROM project_tab pt LEFT JOIN ts_company_arch tca ON pt.project_id = tca.project_id LEFT JOIN ts_job_arch tja ON tca.arch_id = tja.arch_id WHERE pt.state = 1 AND pt.area_id = 2 GROUP BY pt.project_id, pt.project_name
其中allC 我取了别名 就会报错
Reference 'v1' not supported (reference to group function)
解决方案就是不要取别名或者取的别名也为allC,如下:
SELECT pt.project_id, pt.project_name, ROUND(sum(allC), 2) , ROUND(sum(allF), 2), (SELECT allC) t FROM project_tab pt LEFT JOIN ts_company_arch tca ON pt.project_id = tca.project_id LEFT JOIN ts_job_arch tja ON tca.arch_id = tja.arch_id WHERE pt.state = 1 AND pt.area_id = 2 GROUP BY pt.project_id, pt.project_name
相关推荐
解决SVN上传提示Empty directoriesis not supported 解决SVN上传提示Empty directoriesis not supported
网上各种教程无法解决这个工具提示 not supported not listening问题,这个安装包给出了所有需要的文件,并给出了详细的指引。 绝大多数情况你会安装成功。如果你成功了,或者失败了,请给我评论。大家看评论区。
在启动Oracle数据库时提示:ORA-00845 MEMORY_TARGET not supported on this system错误,解决办法
网上各种教程无法解决这个工具提示 not supported not listening问题,这个安装包给出了所有需要的文件,并给出了详细的指引。 绝大多数情况你会安装成功。如果你成功了,或者失败了,请给我评论。大家看评论区。 ...
java解决405 - HTTP method GET is not supported by this URL
NULL 博文链接:https://lectery.iteye.com/blog/485357
Office安装错误Per-user install not supported.txt
这原本可以通过rdpWrap实现支持,但rdpWrap没持续更新,win10更新后就会产生listener state not supported 问题。当前上传版本解决了此问题,在64位win10.0.19042.1052上测试正常。 解压后双击 安装.bat 进行安装 ...
ERROR:ABIs [armeabi] are not supported for platform.Supported ABIs are [arm64-v8a, armeabi-v7的完美解决方案-附件资源
MySQL Cluster is currently not supported in MySQL 8.0. For information about MySQL Cluster, please see MySQL NDB Cluster 7.5 and NDB Cluster 7.6. MySQL 8.0 features. This manual describes features...
ThinkPHP6.1 Filesystem Driver aliyun not supported
Delphi's THandle type when a HWND is passed to a function. E.g.: if (DragDetectPlus(THandle(MyControl->Handle), Point(X, Y))) { ... } * Virtual File Stream formats can only be pasted from the ...
Functional Kotlin Optimize code using Functional Programming Techniques 英文epub 本资源转载自网络,如有侵权,请联系上传者或csdn删除 查看此书详细信息请在美国亚马逊官网搜索此书
MySQL Cluster is currently not supported in MySQL 8.0. For information about MySQL Cluster, please see MySQL NDB Cluster 7.5 and NDB Cluster 7.6. MySQL 8.0 features. This manual describes features...
部分程序在centos下安装时提示:Graphical installers are not supported by the VM
本文讲述了Python使用pip安装报错:is not a supported wheel on this platform的解决方法。分享给大家供大家参考,具体如下: 可能的原因1:安装的不是对应python版本的库,下载的库名中cp27代表python2.7,其它同理...
django 设置settings.py,本文以mysql 为例,说明怎样配置mysql d的连接
C#连接MYSQL8.0的版本老是提示[Authentication method 'caching_sha2_password' not supported by any of the available plugins.] 这个错误,换低版本的MYSQL连接又没有问题,现在把我的经验分享一下,解决这个连接...