这个子查询怎么用hibernate语法写出来 - JAVA论坛

问题点数：0 回复次数：0

这个子查询怎么用hibernate语法写出来

select * from (select SUM(onlinePerson) p, timestamp, marketID from SidOnline group by timestamp, marketID having timestamp<:end and timestamp>=:begin  and  marketID=:marketId) t  where t.p =(
select max(s.p)  from
(select SUM(onlinePerson) p, timestamp, marketID from SidOnline group by timestamp, marketID having timestamp<:end and timestamp>=:begin  and  marketID=:marketId) as s)

搜索更多相关主题的帖子: where　having　hibernate　