I want to generate this SQL code:
Select count(distinct user_id) as ui
from posts
I tried this snippet but it did not work:
knex('posts').countDistinct('user_id').as('ui');
How can I do that?
I found that both count() and countDistinct can parse raw queries like this:
knex('posts').countDistinct('user_id as ui') ;
knex('posts').count('user_id as ui') ;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With