A modern programming language that makes developers happier.

kotlinlang

Hey all, is the best way to return the value of a sum to create an aliased field and pass it into the query like so? Or can I just refer to the column in the `.get()` on the query via the `.sum()` method on the column? Here’s what I have right now:

```
val sumAlias = TransactionsTable.amount.sum().alias("campaignTotal")
TransactionsTable.slice(sumAlias)
    .select { TransactionsTable.campaignID eq campaignID }
    .limit(1)
    .firstOrNull()
    ?.get(sumAlias)
```

Pretty sure you can just do:
```
val sum = TransactionsTable.amount.sum()
TransactionsTable.slice(sumAlias)
    .select { TransactionsTable.campaignID eq campaignID }
    .limit(1)
    .firstOrNull()
    ?.get(sum)
```

Also, I think in most databases sum will always return one row so no need for `.limit(1)` and you can do `.first()` instead

Gotcha. The reason I was doing `.firstOrNull()?.get(sumAlias)` was because `.firstOrNull()` will return a `ResultRow?` so I need to retrieve the actual sum value. Thanks!