Multiple columns in a group by condition in sleep mode

Question

Multiple columns in a group by condition in sleep mode

How to make a Group on demand (for example, Select column1, column2, min (value) from Foo_Bar, where value> 100 group by (Column1, Column2) ) in sleep mode? I wanted to have multiple columns in a group using .

+3

group-by hibernate

Technocrat May 17 '12 at 17:36

source share

1 answer

Jb nizet · Accepted Answer · 2012-05-17T17:51:46+0000

select f.column1, f.column2, min(f.value)
from FooBar f
where f.value > 100
group by f.column1, f.column2

Multiple columns in a group by condition in sleep mode

More articles: