Hibernate Community • View topic - [HQL]count and distinct on multiple columns

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

[HQL]count and distinct on multiple columns

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

DennisS

Post subject: [HQL]count and distinct on multiple columns

Posted: Wed May 06, 2009 4:45 am

Newbie

Joined: Wed May 06, 2009 4:41 am
Posts: 2

Hi,

on SQL i can do sth like
SELECT COUNT (*) FROM (SELECT DISTINCT column1, column2 FROM table1)
to get the number of results for a distinct query. On HQL it is not allowed to
use subqueries in the from-clause.
I there any way i can "decorate" my query with a count or use distinct and count at the same
time on multiple columns without getting all the data from the database to my client

Dennis

Top

DennisS

Post subject: Re: [HQL]count and distinct on multiple columns

Posted: Thu May 07, 2009 2:44 am

Newbie

Joined: Wed May 06, 2009 4:41 am
Posts: 2

Anyone an idea ?

Top

pkleindl

Post subject: Re: [HQL]count and distinct on multiple columns

Posted: Fri May 08, 2009 2:29 pm

Senior

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

SELECT count(DISTINCT column1, column2) FROM table1

didn't try it but could work

Patrik

Top

Page 1 of 1

[ 3 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