Hello,
I am trying to implement a SQL Query like this
Code:
select * from (select * from table order by column) where rownum <= 10;
using Hibernate.
I tried in various ways using simple HQL from statements like
Code:
String SQL_QUERY =" from ( from table as t order by column) where rownum <=10";
->>>org.hibernate.hql.ast.QuerySyntaxException: unexpected token: (
Code:
String SQL_QUERY =" from tableas t where exists ( from tableas z order by colum) and rownum < 10";
->>>java.sql.SQLException: ORA-00907: missing right parenthesis
Does anybody know a solution for this problem?
Bye
qwerter