Hibernate Community • View topic - Count(*) on a group by subquery

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Count(*) on a group by subquery

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

will82

Post subject: Count(*) on a group by subquery

Posted: Wed Mar 30, 2011 8:32 am

Newbie

Joined: Wed Mar 30, 2011 8:13 am
Posts: 1

hi,

I'm playing with hibernate criteria and I'm not able to pop out a way to count the number of rows returned by a groupby query (it's mainly in case of pagination).
Here is an example of my query (no problem with Criteria):

Code:

Select a, b
from MyTable
group by a, b

And here is the derived expected query from the previous one :

Code:

select count(*) from (
   Select a, b
   from MyTable
   group by a, b
)

Is there any way to achieve this with Criteria ? if no, is there any workaround ?

Thanks

William

Top

Page 1 of 1

[ 1 post ]

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