Get the top n records from a list

p4pratik · **Posted:** Tue Feb 26, 2008 3:21 am

Hi all,
I am a newbie to HQL.

I am querying a database using a SQL View. This view returns me a list of records. However, I only want to get the top 10 records using HQL.

So My SQL would be something like this:
select top 10 * from [MyView]

How can I achieve the same using HQL query?? Is there any "top" clause supported by HQL??

carstenpiepel · **Joined:** Tue Feb 19, 2008 6:11 pm **Posts:** 3

Use http://www.hibernate.org/hib_docs/v3/api/org/hibernate/Query.html#setMaxResults(int):

Code:

Query q = sess.createQuery("select cat.name, cat from DomesticCat cat order by cat.name");
q.setMaxResults(10);
List cats = q.list();

Carsten

carstenpiepel · **Joined:** Tue Feb 19, 2008 6:11 pm **Posts:** 3

Sorry, wrong language. Use this instead:

Code:

IQuery q = sess.CreateQuery("from DomesticCat cat");
q.SetFirstResult(10);
IList cats = q.List();

Carsten

NoHuman · **Joined:** Tue Feb 19, 2008 11:26 am **Posts:** 3

carstenpiepel wrote:

Sorry, wrong language. Use this instead:

Code:

IQuery q = sess.CreateQuery("from DomesticCat cat");
q.SetFirstResult(10);
IList cats = q.List();

Carsten

but use

Code:

SetMaxResult(10);

like in his first response