get count of has_many association in rails query

Question

I have a two model. Post and `Comment'.

Post has_may comments.

Query: I want to get the max count of comments in which post.

This should be done by rail query.

Can you please add comment who `down` vote? – Vinay Jun 04 '15 at 09:58 — Vinay, Jun 04 '15 at 09:58

score 0 · Accepted Answer · edited Jul 10 '17 at 15:20

0

@post = Post.
  joins(:comments).
  select('posts.*, count(comments.id) as comment_count').
  group("posts.id").
  first

edited Jul 10 '17 at 15:20

antiqe

answered Jun 04 '15 at 10:08

Vrushali Pawar

I am looking for a query from which I can get the post which have max number of comments among other posts. Now do you understand? – Vinay Jun 04 '15 at 11:31

1 Answers1