I have two entity types Email and Person. Email Stores the the ID of the Person who has been emailed.

Im having trouble figuring out how to write a named query for nHibernate that returns a list of the top 5 people who have recieved the most emails.

The sql for it would be something like this:

SELECT TOP 5 COUNT(*) AS count, ProfileID
FROM dbo.NhsEmail
GROUP BY ProfileID
ORDER BY Count DESC

Can someone give me the pesudo hql for a name query that would do this?

have i asked a stupid question not worthy of the courts attension?

I can get my head round whether this is possible....im used to hibernate queries returning entity classes or sets of entity class, but in this case im returning a count aswell as a Profile...is this possible?

chill. This forum doesn't have the typical 'holier-than-thou' attitude that most do.

I'm not very experienced with HQL, but what you'll want to do is get rid of the count, b/c your collection will tell you that. You'll also want to return various properties of the actual Person object, like doing "SELECT {Person.*} ..."

Hibernate In Action has some great examples, if you don't have that book I'd suggest picking it up. The link is at the top of the page.[/b]