I'm wondering if is possible to convert this HQL query into a criteria api query.
select s1
from Student
where
(
select max(s2.Score)
from Student
where s1.Id = s2.Id
)
= 10
(selects the students that have their max score value equal to 10)
I don't know if I could use a detached criteria because of the 's1.Id = s2.Is' condition
Thanx for anyone who can help me