首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >Rails group by查询仍返回重复记录

问Rails group by查询仍返回重复记录
EN

Stack Overflow用户
提问于 2017-11-27 13:08:57
回答 0查看 420关注 0票数 1

我有一些查询来选择基于skipped_play_id的所有数据,但是当我执行查询时,它仍然返回一些重复的skipped_play_id

代码语言:javascript
复制
user = User.first     
skipped_plays=user.user_skipped_plays.select(:skipped_play_id,:created_at).group(:created_at,:skipped_play_id)

如果我只需要按skipped_play_id分组的查询,为什么我要提供:created_at作为group by参数之一?如果我将查询更改为user.user_skipped_plays.select(:skipped_play_id,:created_at).group(:skipped_play_id)

它会回来的

代码语言:javascript
复制
    ActiveRecord::StatementInvalid: PG::GroupingError: ERROR:  column "user_skipped_plays.created_at" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT  "user_skipped_plays"."skipped_play_id", "user_skippe...
                                                        ^
: SELECT  "user_skipped_plays"."skipped_play_id", "user_skipped_plays"."created_at" FROM "user_skipped_plays" WHERE "user_skipped_plays"."user_id" = $1 GROUP BY "user_skipped_plays"."skipped_play_id" ORDER BY "user_skipped_plays"."id" ASC LIMIT $2
from /Users/fourtyonestudio/.rvm/gems/ruby-2.3.1/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/postgresql_adapter.rb:657:in `prepare

我真的很感谢你的建议

EN

回答

页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/47504276

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档