Napr.:
select max(bid.bidPrice),count(bid.id) from Bid bid group by bid.item.id
Zajimavejsi zapis bude, kdyz ma Item mapovanou kolekci bids (ale neznam
vase UC, tak nevim, zda je to rozumne):
a) select max(bid.bidPrice), count(bid.id) from Item item join item.bids
bid group by item.id
b) select sizeof(item.bids), (select max(bid.bidPrice) from item.bids
bid) from Item item
Dalsi moznosti vymyslet podle
http://www.hibernate.org/hib_docs/reference/en/html/queryhql.html sam.
Lukas
Ivan Polák napsal(a):
Zdravim konferenciu,
mozete mi pomoct prepisat tento select do hibernate query:
select max(b.bid_price), count(*)
from item f
join bid b on b.fk_item_id = f.id
where f.id = 10
group by f.id
triedy su Item a Bid, Item ma : id a Bid ma id, bidPrice a itemId (pre
fk_item_id).
dakujem
Ivan
