sql - How to use group_concat in hibernate criteria? -

sql - How to use group_concat in hibernate criteria? -

i wrote query in mysql using group_concat

select c1,group_concat(c2) table1 sno in(1,4,8,10) grouping c1;

and gives expected result.

now same query want write using hibernate criteria.

simple reply no

why?

hibernate back upwards mutual function/syntax used in multiple database. there ain't group_concat function in microsoft sql server , may in other database well.

solution:

you have execute simple sql query.

sql hibernate