SELECT: DISTINCT

Jump to bottom

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

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

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

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

// SELECT DISTINCT(`field`) AS `fieldDISTINCT` FROM `table`