解决which is not functionally dependent on columns in GROUP BY clause;...sql_mode=only_full_group_by
2023-09-11 14:15:40 时间
问题产生原因:数据库设置了only_full_group_by
模式
解决方案:
- 首先
select
的内容必须有order by
和group by
的字段 - 使用
any_value
举例:
select
id,name,sex
from t_person
group by create_time
order by age
需要把create_time
、age
,放到select的字段里,因为名字可能对应多个,所以需要加上any_value
,修改后的结果如下:
select
id,any_value(name),sex,create_time,age
from t_person
group by create_time
order by age
相关文章
- The Auto Block, blocks my pictures on my website OneTrust
- What “Clustered Index Scan (Clustered)” means on SQL Server execution plan?
- SQL案例分析-地铁换乘线路查询.sql
- SQL Server 占用内存太高,查找占用内存高以及影响其性能的sql语句及解决方法
- English trip V2-B 1 What's on the Menu? 菜单上有什么? Teacher:Tom
- English trip V1 - B 21. On a busy day 忙碌的一天 Teacher:Taylor Key: at on in
- PostgreSQL on duplicate update
- 解决bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00911: 无效字符
- SQL on Hadoop 的真相(2)
- remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it is ncurses-devel.
- SQL join中on与where区别
- 论文阅读:On-line simultaneous learning and recognition of everyday activities from virtual reality performances
- Flink SQL 1.11 on Zeppelin 平台化实践
- Running Spark Streaming Jobs on a Kerberos-Enabled Cluster
- sql server 小技巧(5) Sql server 获取指定字符后的所有字符 - 去掉指定字符前的所有字符
- sql:SQL Server metadata queries
- Sql Server 优化----SQL语句的执行方式与锁以及阻塞的关系
- PHP Warning: Module 'modulename' already loaded in Unknown on line 0
- Error: cannot call methods on draggable prior to initialization; attempted to call
- (4.61)sql server执行SQL遇到错误不中断
- sql server该账户当前被锁定,所以用户'sa'登录失败。系统管理员无法将该账户解锁。(Microsoft SQL Server,错误:18486),登录错误18456
- 【sql server复制】教你使用SQL SERVER复制
- 【sql server镜像】SQL SERVER 基于数据库镜像的主从同步(数据库镜像实践汇总)
- SQL中on条件与where条件的区别
- [daily paper 7]2023 03 05 2011 109 CSX An Extended Compression Format for SpMV on Shared Memory Sys
- E.ON携Google拓展欧洲市场 于德推Sunroof计划
- sql-常见的SQL优化
- 使用paddle RuntimeError: CUDA error: no kernel image is available for execution on the device解决方法