Hi,
Following is the relational table (on postgres)

Table A
id - int
count - int

Table B
id - int
A_id - int

There is one-to-many relation between A->B. For each unique row in Table A there could be more than 1+ child in Table B.

Both Table A and Table B can have large number of records.
So, I would be using the pagination feature of Hibernate.
My question :

I would like to use HQL so that I can only get one row from Table B for each unique A_id.