/*
* 分组聚合 select avg(h.price),max(h.price),min(h.price) from House h
*/
/*
* 各个街道房屋 select avg(h.price),max(h.price),min(h.price) from Street
* s left join s.house h group by s
*/
/*
* 隐式内连接 select avg(h.price),max(h.price),min(h.price) from House h
* group by h.street.
*/
/*
* 街区 房屋 各个县区 h_ s_q三表 select avg(h.price),max(h.price),min(h.price)
* from District d left join d.streets s left join s.house group by
* d.name
*/
/*
* select avg(h.price),max(h.price),min(h.price) from House h group
* by h.streets.district.name
*/
Hibernate-分组统计数据
最新推荐文章于 2019-10-23 13:04:55 发布