knex get total code example

Example: knex.js count

knex('users').count('active', {as: 'a'})Outputs:select count(`active`) as `a` from `users`