java - 如何将带子查询的 SQL 查询转换为 HQL 查询？

Question

我想将以下查询转换为 HQL 查询。我该怎么办？

select * from gpsdata where mobileunitid = '2090818044' and gpsdate in (select gpsdate from gpsdata where mobileunitid = '2090818044' ORDER BY gpsdate DESC LIMIT 1 ) and gpsstatus='true'

Answer 1

Query q = session.createQuery("from GpsData " +
                              "where mobileUnitId = '2090818044' " +
                              "and gpsDate in " +
                              "(select gpsDate from GpsData " +
                              "where mobileUnitId = '2090818044' " +
                              "ORDER BY gpsDate DESC LIMIT 1) " +
                              "and gpsStatus='true'");

，应该可以。