sql --it is not contained in either an aggregate function or the GROUP BY clause.

最新推荐文章于 2023-05-08 09:36:26 发布
最新推荐文章于 2023-05-08 09:36:26 发布
阅读量2.9k 收藏 1
点赞数 1
分类专栏： ——— 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/jyl15732624861/article/details/79371301
版权

关于group by的错误

groupby

表结构：

表

查询语句：

 select * from POM_USER 
 group by Sex
看见这个错误，凭感觉知道改 '*' 为 'Sex',这样就没有错了,不知道为什么，看到一篇文章，豁然开朗：  理解 group by

焦玉丽
关注
  • 1
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 32
    评论
专栏目录
【spark】十 DataFrame min、max、sum必须要用到is not anaggregate function错误，怎么处理
百物易用是苏生
05-21 5968
DataFrame.select(min(substring(col("A"),2,8)),max(substring(col("A"),2,8)),sum(col("B"))) 报错提示需要aggregate by信息 是我用错了,不能使用col("A")来取A列的值再substring， 应该直接用substring("A",2,8) 取a列的第二个字符起的八位字符，取最大值、最小值做时间...
ExeScript.Editor.v2.6.1.0.incl.serial-iOTA
07-28
The included protection module allows obfuscating or encrypting the scripts securely, while the built-in script compiler creates self-contained EXE files ready to be deployed to other workstations. ...
fortigate-cookbook-504-expanded.pdf
09-05
The FortiGate Cookbook 5.0.4 (Expanded Version) Essential Recipes for Success with your FortiGate September 25, 2013 Copyright© 2013 Fortinet, Inc. All rights reserved. Fortinet®, FortiGate®, and FortiGuard®, are registered trademarks of Fortinet, Inc., and other Fortinet names herein may also be trademarks of Fortinet. All other product or company names may be trademarks of their respective owners. Performance metrics contained herein were attained in internal lab tests under ideal conditions, and performance may vary. Network variables, different network environments and other conditions may affect performance results. Nothing herein represents any binding commitment by Fortinet, and Fortinet disclaims all warranties, whether express or implied, except to the extent Fortinet enters a binding written contract, signed by Fortinet’s General Counsel, with a purchaser that expressly warrants that the identified product will perform according to the performance metrics herein. For absolute clarity, any such warranty will be limited to performance in the same ideal conditions as in Fortinet’s internal lab tests. Fortinet disclaims in full any guarantees. Fortinet reserves the right to change, modify, transfer, or otherwise revise this publication without notice, and the most current version of the publication shall be applicable.
ARM v7-M Architecture Application Level Reference Manual.rar
07-16
ARM, the ARM Powered logo, Thumb, and StrongARM are registered trademarks of ARM Limited. The ARM logo, AMBA, Angel, ARMulator, EmbeddedICE, ModelGen, Multi-ICE, PrimeCell, ARM7TDMI, ARM7TDMI-S, ARM9TDMI, ARM9E-S, ETM7, ETM9, TDMI, STRONG, are trademarks of ARM Limited. All other products or service
.NET Core应用类型（Portable apps & Self-contained apps）
10-20
主要介绍了.NET Core应用类型，通常类型用来描述一个特定的执行模型或者基于此的应用，具有一定的参考价值，感兴趣的小伙伴们可以参考一下
zipkin-server-2.22.2-exec.jar
11-13
zipkin-server-2.22.2-exec.jar 文件，github官网下载。 下载地址: https://github.com/openzipkin/zipkin 页面里的： Quick-start The quickest way to get started is to fetch the latest released server as a self-contained executable jar. Note that the Zipkin server requires minimum JRE 8. 点击此处下载的 。 2020年11月13日
Column '###' is invalid in the select list because it is not contained in either an aggregate ......
Alone_in_的博客
11-06 8129
数据库报错：Column 'temTable.customStatus' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. 原因：group by 后面是要跟着的 select 中所有不是聚合函数的字段。 解决：把该字...
Column ‘xxxx‘ is invalid in the select list because it is not contained in either an
weixin_42512282的博客
05-08 1009
如果是MySQL的话。
Object *** is not contained in a resource.
Dollyn（逆风飞扬）
06-11 321
I get a DanglingHREFException: e.g., "org.eclipse.emf.ecore.xmi.DanglingHREFException: The object 'com.example.Foo@2f5dda ()' is not contained in a resource." What do I need to do? All objects need ...
关于UBUNTU网络若干问题的解决办法
自由枫~
04-09 1181
问题一： 误删network-manger,计算机无法上网 解决办法： network-namager被删除或卸载后，系统的网络已经处于未托管状态。就是说，得自己手动设置有线或无线上网来重新安装network-manager 有线设置(如果有线网卡对应eth0话)如下： 设置IP： sudo ifconfig eth0 192.168.1.33 netmask 255.255.255.0
ubuntu server安装注意
fjfdszj的专栏
08-10 1162
 对于ubuntu server 8.04的安装注意，镜像文件才524 MB。1.首先，关闭网络连接。否则在安装apt找到镜像升级过程，如果网速不快的话，那么是十分痛苦的等待。我就是等了一整天，机子还是没反应过来，还好是周末。2.在没有安装网络软件时，速度马上提升。3.对于本人是将ubuntu安装于sun virtualBox上。而对于宿主机的内存是6G，所以宿主机
绕过云WAF防护获取网站真实IP
qq_39416206的博客
04-02 5074
绕CDN找真实ip
postgresql 聚合的暗坑
weixin_33709219的博客
01-27 1196
--对于聚合操作，pg约束是不严格的，比如如下sql中，group by 缺少 name，但也能执行 postgres=# select id,name ,count(*) from t group by id; id | name | count ----+------+------- 1 | bcd | 1 2 | abc ...
invalid in the select list because it is not contained in either an aggregate function or the GROUP ...
weixin_30532987的博客
09-04 521
Column 'dbo.tbm_vie_View.ViewID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. https://stackoverflow.com/questions/13999817/reason-...
InterBase 與 FireBird 語法兼容問題記錄
Avan_Lau的专栏
03-02 2281
序號語法錯訊解法1select max(adr1001) from gp0adr1 order by adr1001Invalid expression in the ORDER BY clause (not contained in either an aggregate function or th
[解决方案]spark 2.4 报错：grouping expressions sequence is empty, *** is not an aggregate function.
SYP'S Blog
03-13 1万+
一、报错详情 code select id , content_map from test_db.test_tb having content_map is not null error grouping expressions sequence is empty, and 'test_db.test_tb .`id`' is not an aggregate function. Wrap ...
浏览器控制台警告错误[DOM] Password field is not contained in a form:或者是 input 警告[DOM]...
热门推荐
呆子小木心的博客
09-24 2万+
前端编写代码时，查看浏览器控制台会出现的警告错误[DOM] Password field is not contained in a form:或者是 input 警告[DOM] Input elements should have autocomplete attributes (suggested: “new-password”) 1，出现警告错误[DOM] Password field is not contained in a form:的解决方法是： 在input标签外添加上标签form <
mysql不分组的聚合函数_为什么MySQL允许“分组依据”？查询没有聚合函数？
weixin_42363565的博客
01-18 289
Surprise -- this is a perfectly valid query in MySQL:select X, Y from someTable group by XIf you tried this query in Oracle or SQL Server, you’d get the natural error message:Column 'Y' is invalid in ...
pgsql报错 must appear in the GROUP BY clause or be used in an aggregate function
Programmer_FuQiang的博客
12-02 1万+
must appear in the GROUP BY clause or be used in an aggregate function 今天在分组统计的时候pgsql报错must appear in the GROUP BY clause or be used in an aggregate function，在mysql里面是可以的，但是pgsql报错，这是pgsql一个常见的聚合问题，在SQL3标准以前，选择显示的字段必须出现在在GROUP BY中。下面我把问题描述一下： 数据是这...
sql报错Column 'uf_XMYSHZ_dt1.ysyysje' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY claus
最新发布
05-30
这个错误信息是因为在SELECT语句中同时使用了聚合函数和非聚合函数，但没有在GROUP BY子句中将非聚合函数进行分组。解决方法是将非聚合函数也添加到GROUP BY子句中，或者使用聚合函数对非聚合函数进行计算。例如： 错误示例： ``` SELECT name, SUM(salary), age FROM employee GROUP BY age; ``` 正确示例： ``` SELECT name, SUM(salary), age FROM employee GROUP BY name, age; ``` 或者： ``` SELECT MAX(name), SUM(salary), MAX(age) FROM employee; ```

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 32
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值