如何写hql语句,得到查找结果的前十条数据,
例如像sql语句中的这样
"select * from (SELECT * FROM TBLCONSULTFORM WHERE VALID_FLAG=1 AND CUST_ID =" & "'" & strTempq & "'" & " order by SERIES_ID DESC ) where rownum < 10 "
例如像sql语句中的这样
"select * from (SELECT * FROM TBLCONSULTFORM WHERE VALID_FLAG=1 AND CUST_ID =" & "'" & strTempq & "'" & " order by SERIES_ID DESC ) where rownum < 10 "
session.createQuery(hql).setFirstResult(offset).setMaxResults(pageSize).list();
offset=0
pageSize=10