把一个查询结果当查询条件的SQL语句转换为HQL语句

[人在路途之发现之旅]

select * FROM
(select *
from cv_r_resume a
where
(a.VIDEO_ID is not null and a.VIDEO_ID <> '' )
and (a.RECD_USER_ID is null or a.RECD_USER_ID != '-2')
and (a.VIDEO_AUDIT_STATUS= '0' or a.VIDEO_AUDIT_STATUS= '2') ) t
order by t.UPDATE_TIME asc limit 10;
这个SQL语句怎么转换成HQL语句啊？

[shinger126]

引用 楼主 qq_36377133 的回复:

select * FROM
(select *
from cv_r_resume a
where
(a.VIDEO_ID is not null and a.VIDEO_ID <> '' )
and (a.RECD_USER_ID is null or a.RECD_USER_ID != '-2')
and (a.VIDEO_AUDIT_STATUS= '0' or a.VIDEO_AUDIT_STATUS= '2') ) t
order by t.UPDATE_TIME asc limit 10;
这个SQL语句怎么转换成HQL语句啊？

明明一句话就可以的为什么要嵌套3层？

[人在路途之发现之旅]

这样嵌套起来执行的快，不然需要很久