Aggregation query

[Gustavo Ramos­]

Hi all,

How can I make a query like this with slick?

select count(value), sum(value) from tableA;

Thanks,

--
Gustavo R. Almeida

[Richard Dallaway]

The way I tend to do that is to use the “group by true” trick to get access to query and run aggregations on it:

val q = tableA.groupBy(_ => true).map { case (key, query) => (query.length, query.map(_.value).sum) }

The SQL will be something like:

select count(1), sum(value) from tableA group by true

Anyone have a nicer/better way?

Richard

--

---
You received this message because you are subscribed to the Google Groups "Slick / ScalaQuery" group.
To unsubscribe from this group and stop receiving emails from it, send an email to scalaquery+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/scalaquery/CAAn8MC6vUmuOuOS8VFuqkig-CquZJ%2BxUhcoWSwF%2BdNEYwbQ9YQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.