hql话语总结

hql语句总结

1、使用in且按照in里面的集合顺序查询结果

?

select sum(l.costWorktime), DATE_FORMAT(l.workDate, '%Y-%m') from Log l where 1=1 group by DATE_FORMAT(l.workDate, '%Y-%m')