Hibernate Community • View topic - Fetch Last Row of a table

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Fetch Last Row of a table

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

patelpritesh

Post subject: Fetch Last Row of a table

Posted: Wed Apr 12, 2006 12:44 pm

Newbie

Joined: Mon Mar 13, 2006 2:29 pm
Posts: 1

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3.1.2

What is the equivalent HQL for the following mysql query for fetching last row of a table?

SELECT * FROM tbluser order BY iuserid DESC LIMIT 1

Top

r1ch

Post subject:

Posted: Wed Apr 12, 2006 1:13 pm

Regular

Joined: Wed Aug 25, 2004 6:23 am
Posts: 91

You can apply the sort in the HQL and then use query.setMaxResults(1); to limit to 1 result.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate 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