PostgreSQL-GROUP BY使用聚合函数
技术问答
137 人阅读
|
0 人回复
|
2023-09-13
|
我在SO找到了一些主题,但还是找不到适合我查询的设置。* x' k3 D) b5 e, \2 b6 M
这是查询,在本地主机上运行得很好:/ I. s+ D4 e/ f9 Y. S o3 N6 D
@cars = Car.find_by_sql('SELECT cars.*,COUNT(cars.id) AS counter FROM cars LEFT JOIN users ON cars.id=users.car_id GROUP BY cars.id ORDER BY counter DESC')但是在Heroku上,我 遇到了-GROUP BY子句 上述错误,或在聚合函数中使用 。 S8 R' Z$ X( X6 H+ P ]
然后,我在某个地方读到,我应该指定表中的所有列,所以我尝试了以下操作:
' T9 k2 L& f7 K+ {@cars = Car.find_by_sql('SELECT cars.id,cars.name,cars.created_at, cars.updated_at,COUNT(cars.id) AS counter FROM cars LEFT JOIN users ON cars.id=users.car_id GROUP BY (cars.id,cars.name,cars.created_at,cars.updated_at) ORDER BY counter DESC')但这在本地主机上不起作用,在Heroku上也不行…
/ a6 o+ |9 t" F3 C* a& e查询的正确配置是什么?
. {( [! H" K) _* k V. ~ ' P( T; l$ g+ `: B0 f+ X2 k# E
解决方案: |
|
|
|
|
|