getting count(*) using createSQLQuery in hibernate?
Posted
by JohnSmith
on Stack Overflow
See other posts from Stack Overflow
or by JohnSmith
Published on 2010-04-01T10:48:08Z
Indexed on
2010/04/01
10:53 UTC
Read the original article
Hit count: 637
I have several sql queries that I simply want to fire at the database. I am using hibernate throughout the whole application, so i would prefer to use hibernate to call this sql queries.
In the example below i want to get count + name, but cant figure out how to get that info when i use createSQLQuery().
I have seen workarounds where people only need to get out a single "count()" from the result, but in this case I am using count() + a column as ouput
SELECT count(*), a.name as count FROM user a
WHERE a.user_id IN (SELECT b.user_id FROM user b)
GROUP BY a.name
HAVING COUNT(*) BETWEEN 2 AND 5;
fyi, the above query would deliver a result like this if i call it directly on the database:
1, John
2, Donald
1, Ralph
...
© Stack Overflow or respective owner