Question

以下SQL语句怎么写成hql语句呢？

select * from (select row_number() over (order by id ) as rowNum,* from TruckSource) as t where status = '1' and rowNum between 1 and 9 order by publish_time desc

Answer 1

用hql的话要用到hibernate自动生成的表结构类，简单些一个结构：
String hql="select t.类中对应的列 from 类名 t where 条件";
至于rowno>0只需在下边判断一下返回的结果就行了

追问

能具体用hql语句举个例子吗？

Answer 2

hql不支持复杂的row_number()函数，
下面是个简单的例子：
SQL: Query the first N records
ORACLE :
SELECT * FROM TABLE1 WHERE ROWNUM<=N
HQL: from table1 t order by t.createTime desc where rownum<=n