|
发表于 2022-10-8 14:31:21
|
显示全部楼层
时间是带时分秒的,我做了几个视图,其中查明细的视图能根据时间段选择;按一定维度(部门、项目等)统计的视图选择时间段就不行。
明细查询视图JPQL语句:SELECT o FROM procostinfo o;
维度统计视图JPQL语句select o.proname,count(o.proname) as cno,sum(o.costnum) as cnum from procostinfo o group by o.proname order by sum(o.costnum) desc |
|