hql equivalent query to this sql query

Question

Select top 1 from <tablename>

what is hql query for the above ?

score 5 · Answer 1 · answered Mar 08 '10 at 12:15

5

Just write a normal query, ans use "SetMaxResult" to limit your results.

I.e.

return  getSession().createQuery("from items order by id asc")
            .setMaxResults(1)
            .list();

answered Mar 08 '10 at 12:15

Marcos Placona

score 2 · Answer 2 · edited May 23 '17 at 10:33

2

It seems you must use the setMaxResults() method.

See for example this question+answer : How do you do a limit query in HQL

edited May 23 '17 at 10:33

Community

answered Mar 08 '10 at 12:15

Pascal MARTIN

score 1 · Answer 3 · answered Mar 08 '10 at 12:18

1

You'll probably want to use the setMaxResults of the Query Object.

To my knowledge, HQL does not support top or limit.

answered Mar 08 '10 at 12:18

tschaible

3 Answers3