Hi All

I am using Hibernate version2

I have a situation where in I am retreiving a list of few records. But I just want the first record from the list.

Normally in plain Oracle SQL query I would do something like this

SELECT * FROM
(SELECT * FROM employees ORDER BY employee_id)
WHERE ROWNUM < 2;

How can I replicate this using Hibernate createSQLQuery.

I reckon this way of doing a TOP-n query is not understood by Hibernate.


Do post your suggestions on the same


Regards,

Does Hibernate2 have this method in Query interface?

ROWNUM is supported in HQL, so you can use it just as you would in SQL.

Ryan-