https://kotlinlang.org logo
#exposed
Title
# exposed
h

hfhbd

09/07/2021, 2:19 PM
Hey, how would you write this query in Exposed?
Copy code
select name, min(time), max(time) from data group by name
In https://github.com/JetBrains/Exposed/wiki/DSL#group-by there is no good sample
b

Bogdan

09/07/2021, 2:41 PM
something like
Copy code
val min = table.time.min() // so as not to create constantly
  val min = table.time.max()
  table.slice(table.name, min, max)
     .selectAll()
     .groupBy(table.name)
h

hfhbd

09/07/2021, 2:59 PM
Thank you! This was too easy 😄
4 Views