Hibernate Community • View topic - How to fetch top 5 records from database using hql

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

How to fetch top 5 records from database using hql

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

rakesh.kopperapu

Post subject: How to fetch top 5 records from database using hql

Posted: Mon Dec 01, 2008 12:35 am

Newbie

Joined: Wed Oct 22, 2008 3:58 am
Posts: 4
Location: banaglore

hi all
i am using hibernate query language,i want latest 5records from data base,i am getting records according to date and time
but in view i want to diaplay only 5 records
can u tell any condition to put in query that will get only top 5records
i tried with limit,rownum conditions but i didn't get it
Thanks in advance

Top

rudradutt

Post subject:

Posted: Mon Dec 01, 2008 2:22 am

Newbie

Joined: Tue Nov 18, 2008 6:08 am
Posts: 14

you can do is

Code:

Session session = HibernetUtil.getSessionFactory().openSession();
Criteria criteria = session.createCriteria(ClassName.class);
criteria.setFirstResult(1);
criteria.setMaxResults(5);
List result = criteria.list();
session.close();

for imports take suggestions from your IDE.

this will give you top 5 results from your database
the query will be

Quote:

from table limit 1,5

assuming your top five records are saving system time
hope this helps

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum