在真正的sql中而不是Rails-ish中,您将编写:
SELECT
count(CASE WHEN confirmed THEN 1 END) AS n_confirmed,
count(CASE WHEN NOT confirmed THEN 1 END) AS n_unconfirmed,
...
FROM posts
...
希望会对您有所帮助。不知道如何/是否可以将其翻译为ActiveRecord。
如何根据布尔值对同一字段进行两次计数?
在真正的sql中而不是Rails-ish中,您将编写:
SELECT
count(CASE WHEN confirmed THEN 1 END) AS n_confirmed,
count(CASE WHEN NOT confirmed THEN 1 END) AS n_unconfirmed,
...
FROM posts
...
希望会对您有所帮助。不知道如何/是否可以将其翻译为ActiveRecord。