sql转换为hql语句 该如何转换

Question

select * from (select * from M_asset m where 1=1 and m.total>0 and m.motorRoom = '65' order by m.datcreate desc )a where 1=1这个sql 是正确的可以查询到数据 转换成hql该怎么写呢 我是这么写的 但是报错 select a from (select m from Asset m where 1=1 and m.total>0 and m.motorRoom = '65' order by m.datcreate desc )a where 1=1 其中M-asset是数据库中的表名 而Asset为类名