sql 平均值为什么要 full group by??
› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
This topic created in 1656 days ago, the information mentioned may be changed or developed.
 |
1
|
1 |
itechifyApr 29, 2022 via Android
2
你把 sql 简化贴出来，或许你写错了吧
|
 |
3
就是想求 在一个时间点里，以 army_id 为组的 x 的平均值，
SELECT avg(x) as ax, avg(y) as ay, avg(z) as az, FROM `path` WHERE `space` = 'xxxxxxx' GROUP BY army_id ORDER BY `game_time`, `team_num`, `team_position` []( https://imgtu.com/i/LzI2FJ) |
 |
NoahVISep 9, 2022
4
你写的 sql 不规范，group by 的字段 需要在聚合函数里面用到
|
Select Language