how to use rownum in hibernate for greater or less

Question

Hi,

SELECT * FROM ABC WHERE PARATYPE = 'A' AND MODELID = '50' AND 'BA1' BETWEEN RAWMIN AND RAWMAX AND ROWNUM < 2 ;

I have the above query .i have difficulty in converting rownum < 2 in plsql to hibernate query. Can u help me .it's urgent. Thank You.

Answer 1

for '<' we use < in hql