Hibernate Community • View topic - forcing rows with null to be the last in any sorting order

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

forcing rows with null to be the last in any sorting order

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

angelochen960

Post subject: forcing rows with null to be the last in any sorting order

Posted: Thu May 07, 2009 6:46 pm

Newbie

Joined: Mon Jul 21, 2008 5:40 am
Posts: 16

I would like to be able to have Hibernate sort a
column of data and have the nulls always show up last -- regardless of
the sort order, any idea how to achieve this?

Thanks,

Top

pkleindl

Post subject: Re: forcing rows with null to be the last in any sorting order

Posted: Fri May 08, 2009 2:19 pm

Senior

Joined: Thu Jan 08, 2009 3:48 pm
Posts: 168

order by coalesce(columnName, maxValue)

coalesce takes the first not null value, meaning if a value is present the the value is taken, otherwise maxValue

Rating is welcome

Patrik

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