SELECT: COUNT

Ali Amirnezhad edited this page Jul 23, 2019 · 2 revisions

const query = myQueryBuilder
    .SELECT({ $COUNT: 'field' })
    .from('table')
    .get();

// SELECT COUNT(`field`) FROM `table`

const query = myQueryBuilder
    .SELECT({ $COUNT: { field: 'fieldCOUNT' } })
    .from('table')
    .get();

// SELECT COUNT(`field`) AS `fieldCOUNT` FROM `table`

const query = myQueryBuilder
    .SELECT({ $COUNT: { '*': 'COUNT' } })
    .from('table')
    .get();

// SELECT COUNT(*) AS `COUNT` FROM `table`