Hibernate Community • View topic - how can create this HQL

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

how can create this HQL

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

MarkDong

Post subject: how can create this HQL

Posted: Tue Apr 27, 2004 2:50 am

Newbie

Joined: Tue Apr 27, 2004 2:36 am
Posts: 12

sorry, My english is poor, i will try to describe clearlly.

I have a Table to record the information when a user borrowed a book

the struct of the table is below

Code:

RecordID  
UserID     
BookID
BorrowTime

I want to count the book's be borrowed times, so I create a hql like this

Code:

select Rocord.book, count(*) from Record as Record group by Record.book

but it is not be sorted

I want it be sorted by total borrowed times,
how can i create the hql

Top

GG_Peter

Post subject:

Posted: Mon May 03, 2004 6:01 am

Regular

Joined: Wed Apr 21, 2004 10:57 am
Posts: 62
Location: Hasselt, Belgium

As shown in the example in the reference manual chapter 11.10.

Code:

select cat
from eg.Cat cat
    join cat.kittens kitten
group by cat
having avg(kitten.weight) > 100
order by count(kitten) asc, sum(kitten.weight) desc

In your code this would make :

Code:

select Record.book, count(*) 
from Record as Record 
group by Record.book 
order by count(*)

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