Hibernate Community • View topic - order by aggregate function?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

order by aggregate function?

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

mjs

Post subject: order by aggregate function?

Posted: Fri Jul 02, 2004 12:16 pm

Newbie

Joined: Tue May 04, 2004 11:51 am
Posts: 8

Is it possible to "order by" an aggregate function? I want to do the equivalent of:

Code:

select
    customer.state, count(*) as n
from
    customer
group by
    customer.state
order by
    n;

but Hibernate doesn't like "count(*) as n". ("order by count(*)" also doesn't work either.)

Top

david

Post subject:

Posted: Fri Jul 02, 2004 10:15 pm

Hibernate Team

Joined: Tue Aug 26, 2003 7:19 pm
Posts: 2364
Location: Brisbane, Australia

Some database's allow a column index number, eg order by 1, for this situation.

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