I have a Book table
Book_primary_key | book_id | book type
1 1 fiction
2 1 tech
3 2 basic
4 1 alien

If book _id has 100 of id's with '1' and and only 30 books of book_id '2'
Can I write a Hibernate criteria query to limit id's 1 and 2 to 20 each i.e. twenty rows containing book_id '1'
and twenty rows with book_id '2'

Criteria criteria = (Criteria) session.createCriteria(Book.class);
criteria.addOrder(Order.asc("bookId"));
.
.
.
return criteria.list();
Thanks !