How to group data in PostgreSQL

Question

Task.select('task_name, id, COUNT(*) AS cnt').group(:task_name).having('cnt > 1')

What's wrong with this query I getting error like : PG::UndefinedColumn: ERROR: column "cnt" does not exist

Please Help me in this query.

Thanks In Advance

Kevin Sylvestre · Accepted Answer · 2014-05-10 04:25:37Z

1

Try (note the duplication of the function in the having clause):

Task.select("..., COUNT(*) AS cnt").group("...").having("COUNT(*) > 1")

answered May 10, 2014 at 4:25

Kevin Sylvestre

38.2k33 gold badges159 silver badges235 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1