SELECT: MAX

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

const query = myQueryBuilder
    .SELECT({ $MAX: 'price' })
    .from('users')
    .get();

// SELECT MAX(`price`) FROM `users`

const query = myQueryBuilder
    .SELECT({ $MAX: { price: 'priceMAX' } })
    .from('users')
    .get();

// SELECT MAX(`price`) AS `priceMAX` FROM `users`