from HotelSendtime b where b.sendtime in (select max(t.sendtime) form HotelSendtime t where t.hotelLogout = 'F' group by t.hotelId) order by b.sendtime desc
如上SQL如果在Hibernate中实现,先谢过
...全文
1731打赏收藏
Hibernate如何实现嵌套查询
from HotelSendtime b where b.sendtime in (select max(t.sendtime) form HotelSendtime t where t.hotelLogout = 'F' group by t.hotelId) order by b.sendtime desc 如上SQL如果在Hibernate中实现,先谢过