ikzekly/rails_count-of-assotiation

Last active September 2, 2018 20:24

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/ikzekly/ad363b8dcdb7a067840ef5923caa0249.js"></script>
Save ikzekly/ad363b8dcdb7a067840ef5923caa0249 to your computer and use it in GitHub Desktop.

Download ZIP

Take all users, who having five and less invoices

Raw

rails_count-of-assotiation

User.joins('LEFT JOIN "invoices" ON "invoices"."merchant_id" = "users"."id"').group("users.id").having("count(*) <= ?", 5)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment